Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

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.

...

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.

 


Legal
Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources