Required access rights - Metasys - LIT-12011202 - Software Application - Metasys Database Manager - 13.0

Metasys Database Manager Help

Brand
Metasys
Product name
Metasys Database Manager
Document type
User Guide
Document number
LIT-12011202
Version
13.0
Revision date
2023-08-14
Product status
Active
Language
English

The content that you can view and the steps that you can perform in the Metasys Database Manager depend on your Microsoft Windows® access rights and on the Microsoft SQL Server privileges assigned to your Windows login.

Table 1. Windows Access Rights

Operating System

Operating System access rights

Corresponding SQL Server access rights (if using Windows authentication to access SQL)

Functionality

Windows® 11 Pro and Windows® 11 Enterprise versions 22H2, 21H2 (64-bit) General Availability Channel (GAC)

Windows® 10 Pro and Windows 10 Enterprise Editions versions 21H2, 22H2 (64-bit).

Windows® Server® 2022 (64-bit)

Windows® Server® 2019 (version 1809 or later) (64-bit)

Administrator

System Administrator

You are able to see and do everything in the Metasys Database Manager.

Member of Administrator Group

Public User

You can view only the Statistics tab, you cannot use Expert Mode, and you cannot access the Settings window.

System Administrator

You are able to see and do everything in the Metasys Database Manager.

Standard User

Public User

You can view only the Statistics tab, you cannot use Expert Mode, and you cannot access the Settings window.

Note:

To allow a member of the OS Administrator group to function as a SQL Server System Administrator, you must take special steps:

  1. For database management using Metasys Database Manager, you must click Yes in the User Account Control window that appears when you attempt to open the Metasys Database Manager. See Opening the Metasys database manager to manage your databases for more information.
  2. To view and change database monitoring settings in Metasys Database Manager, close the Metasys Database Monitor, right-click Metasys Database Monitor from the Start menu, select Run as Administrator, and click Yes in the User Account Control window. See Accessing/Starting monitoring settings for more information. The Detailed procedures section mentions these special steps.