Page History
...
| Tip |
|---|
The Azure SQL recommended permissions for managed instances in SQLDM are the same as On-Premises recommended permissions. |
Minimum Permissions Azure SQL
SQL Diagnostic Manager now includes a SQL script to create a new user with minimum permissions for the product to function:
- Use the Find/Replace function to locate and replace all references of 'SQLdmConsoleUser' with the name of your SQLdm Monitor User.
- Connect to the Azure SQL Server, execute the first section of the script against the master database and the second section of the script against the target databases.
Find the MinimumPermissionsAzure.sql script below:Attachments upload false old false labels minimum
Recommended Permissions Azure SQL
SQL Diagnostic Manager now includes a SQL script to create a new user with minimum permissions for the product to function:
...
| Info |
|---|
Review the Minimum and Recommended Permissions for Azure SQL for more details on the permissions you need to create a new user for Azure SQL Database. |