Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Info

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 for Azure SQL are detailed, as follows:

Tip

The Azure SQL recommended permissions for managed instances in SQLDM are the same as On-Premises recommended permissions.

Anchor
minazuresql
minazuresql
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:

  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, 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 MinimumPermissionsAzure.sql script below:
    Attachments
    uploadfalse
    oldfalse
    labelsminimum

Anchor
recomazuresql
recomazuresql
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:

  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
    previewfalse
    uploadfalse
    oldfalse
    labelsrecommended


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.

Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse