You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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

For more information about the characteristics of the Server admin and Azure Active Directory admin accounts, review Controlling and granting database access to SQL Database and SQL Data Warehouse.

The user creation scripts are detailed, as follows:

Minimum Permissions Azure SQL

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

  1. Use the Find/Replace function to locate and replace all references of 'SQLdmConsoleUser' with the name of your SQLdm Monitor User.
  2. 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:

Recommended Permissions Azure SQL

SQL Diagnostic Manager now includes a SQL script to create 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 second section of the script against the target databases.
    Find the RecommendedPermissionsAzure.sql script below:



  • No labels