Recommended permissions for Azure
SQL Diagnostic Manager now includes a SQL Script to create a new user for Azure SQL Database Standard and Basic Tier with the minimum and necessary permissions for the product to function. Also, includes additional permissions that are required for trace and xevent manipulation.
- Use the Find/Replace function to locate and replace all references to 'SQLdmConsoleUser' with the name of your SQLdm User.
- Connect to the SQL Server that is hosting your SQLdm Repository database and execute the script found under the name of RecommendedPermissionsAzure.sql in the following path:
C:\Program Files\Idera\Idera SQL diagnostic manager\User Creation Scripts
Recommended permissions Azure replication mirroring
Also, it includes a SQL Script to create new user for Azure SQL Database Standard and Basic Tier with minimum and necessary permissions for the product to function. This script has additional permissions required for trace, xevent manipulation, mirror, and replication.
- Use the Find/Replace function to locate and replace all references to 'SQLdmConsoleUser' with the name of your SQLdm User.
- Connect to the SQL Server that is hosting your SQLdm Repository database and execute this script.
You can find this script under the name of RecommendedPermissionsAzureReplicationMirroring.sql in the following path:
C:\Program Files\Idera\Idera SQL diagnostic manager\User Creation Scripts
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.