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.
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, the IDERA Newsfeed, and SQL Diagnostic Manager Mobile.
Note that users who belong to the sysadmin role on the SQL Diagnostic Manager Repository always have Administrator powers.
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:
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.
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.
Once you add SQL Diagnostic Manager Permissions, the Edit Login Permissions window allows you to edit login permissions.
Click the Delete button to remove the previously added login from SQL Diagnostic Manager.
You can toggle non-system, SQL Diagnostic Manager login permissions by checking and clearing the associated box in the Enabled column.
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.