Page History

The minimum permission required to run an a user creation script for Azure SQL is Server Admin rights.

...

SQL Diagnostic Manager now includes a SQL script to create a new user with minimum permissions for the product to function:

...

SQL Diagnostic Manager now includes a SQL script to create a new user with minimum permissions for the product to function:

1. Use the Find/Replace function to locate and replace all references to 'SQLdmConsoleUser' with the name of your SQLdm Monitor User.
2. Connect to the Azure SQL Server and execute the first section of the script against the master database and the second section of the script against the target databases.
   Find the RecommendedPermissionsAzure.sql script below:
   

   Attachments
   preview false upload false old false labels recommended

...