Page History

In many SQL Server 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.

...

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 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:

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 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.

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >

...

...