SQL Diagnostic Manager allows you to monitor SQL Server instances without SysAdmin rights. However, these lowered permissions limit the availability of data.
The user creation scripts are detailed, as follows:
SQL Diagnostic Manager also includes a SQL script to create a new user with minimum permissions necessary for the product to function.
These are the recommended permissions on-premises: GRANT SERVER LEVEL PERMISSIONS /** Assign VIEW SERVER STATE Permissions to SQLdmCollectionUser **/ /** Assign VIEW ANY DEFINITION Permissions to SQLdmCollectionUser **/ /** Assign VIEW ANY DATABASE Permissions to SQLdmCollectionUser **/ GRANT ADDITIONAL XEVENTS AND TRACE PERMISSIONS /** Assign ALTER TRACE Permissions to SQLdmCollectionUser **/ /** Assign ALTER ANY EVENT SESSION Permissions to SQLdmCollectionUser **/ GRANT CREATE ANY DATABASE TO [SQLdmCollectionUser] |
SQL Diagnostic Manager now includes a SQL script to create a new user with minimum permissions for the product to function.
| | | | | | | |