Page History
...
The user creation scripts are detailed, as follows:
| Anchor |
|---|
...
|
...
|
...
Recommended permissions on-premises
SQL Diagnostic Manager now also includes a SQL script to create a new user with minimum permissions necessary for the product to function.
- Use the Find/Replace function to locate and replace all references of 'SQLdmCollectionUser' with the SQL user that is to be used for monitoring the SQL Server instance.
- Connect to the SQL Server that you want to monitor with the Admin user and run this script to create the SQL user with the minimum recommended permissions required to view the data on most of the screens of the application.
Find the MinimumPermissionsOnPremisesRecommendedPermissionsOnPremises.sql script below:Attachments preview false upload false old false patterns MinimumPermissionsOnPremisesRecommendedPermissionsOnPremises.sql sortBy name page User Creation Scripts On Premises - When registering the instance in SQL Diagnostic Manager, specify the SQL account that was created through the script so that SQL Diagnostic Manager connects to the monitored instance using the newly created account.
| Info | ||
|---|---|---|
| ||
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] |
| Anchor | ||||
|---|---|---|---|---|
|
...
premises
SQL Diagnostic Manager also now includes a SQL script to create a new user with minimum permissions necessary for the product to function.
- Use the Find/Replace function to locate and replace all references of 'SQLdmCollectionUser' with the SQL user that is to be used for monitoring the SQL Server instance.
- Connect to the SQL Server that you want to monitor with the Admin user and run this script to create the SQL user with the recommended minimum permissions required to view the data on most of the screens of the application.
Find the RecommendedPermissionsOnPremisesMinimumPermissionsOnPremises.sql script below:Attachments preview falseupload false old false patterns RecommendedPermissionsOnPremisesMinimumPermissionsOnPremises.sql sortBy name page User Creation Scripts On Premises - When registering the instance in SQL Diagnostic Manager, specify the SQL account that was created through the script so that SQL Diagnostic Manager connects to the monitored instance using the newly created account.
...