In many SQL Server production environments, there are several different types of users, such as DBAs, Operators, Help Desk Users, Administrators, and Auditors to name a few. Within each of these groups, there may be several sub-groups of responsibility, such as a DBA that manages a certain set of high-security databases that other DBAs do not. SQL Diagnostic Manager allows you to designate the access both individual users and groups of users have within SQL Diagnostic Manager.
When Application Security is enabled, the only users who have access to SQL Diagnostic Manager are those who belong to the sysadmin role on the SQL Diagnostic Manager Repository. All other users must be added to SQL Diagnostic Manager.
Enable Application Security
Once you enable Application Security, you must add User Permissions for each user you want to give SQL Diagnostic Manager access. Based on the assigned permissions, each user can only access a subset of monitored SQL Server instances. These security settings are enforced in the SQL Diagnostic Manager Console.
Note that users who belong to the sysadmin role on the SQL Diagnostic Manager Repository always have Administrator powers.
Available actions on the Application Security window
The Application Security window lists each login name and the type of access the login has to SQL Diagnostic Manager. The following actions are available on the Application Security window:
Disable/Enable Application Security
You can toggle Application Security on and off using the associated icon. Disabling Application Security gives all SQL Diagnostic Manager users full access to SQL Diagnostic Manager.
Add SQL Diagnostic Manager Permissions
You can open the Add SQL Diagnostic Manager Permissions wizard by clicking the Add button on the Application Security window. This wizard allows you to add SQL Server Logins, Windows Users, and Group accounts and assign them SQL Diagnostic Manager view, modify, and administration privileges.
Edit Login Permissions
Once you add SQL Diagnostic Manager Permissions, the Edit Login Permissions window allows you to edit login permissions.
Delete Login Permissions
Click the Delete button to remove the previously added login from SQL Diagnostic Manager.
Enable/Disable Permissions
You can toggle non-system, SQL Diagnostic Manager login permissions by checking and clearing the associated box in the Enabled column.
Export SQL Diagnostic Manager Permission Settings to Excel
You can export all your SQL Diagnostic Manager Permission settings to Microsoft Excel by right-clicking any user in on the Application Security window and selecting Export to Excel.