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. SQLdm 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 SQLdm are those who belong to the sysadmin role on the SQLdm Repository. All other users must be added to SQLdm.
Enable Application Security
Once you enable Application Security, you must add User Permissions for each user you want to give SQLdm 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 SQLdm Console, the Idera Newsfeed, and SQLdm Mobile.
Note that users who belong to the sysadmin role on the SQLdm 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 SQLdm . 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 SQLdm users full access to SQLdm.
Add SQLdm Permissions
You can open the Add SQLdm 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 SQLdm view, modify, and administration privileges.
Edit Login Permissions
Once you add SQLdm 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 SQLdm.
Enable/Disable Permissions
You can toggle non-system, SQLdm login permissions by checking and clearing the associated box in the Enabled column.
Export SQLdm Permission Settings to Excel
You can export all your SQLdm Permission settings to Microsoft Excel by right-clicking any user in on the Application Security window and selecting Export to Excel.