To monitor an Azure SQL server Server using SQL Diagnostic Manager, you have to create a SQL Server user on the instance with the following minimum permissions:
...
- Minimum permissions plus Control and db_datawriter.
- Control - Grants permissions on the securable.
- db_datawriter - Grants access to tables and views within a database.
Tip |
---|
Recommended permissions are on a database level. |
Scroll pdf ignore |
---|
Newtabfooter |
---|
alias | IDERA |
---|
url | http://www.idera.com |
---|
| | Newtabfooter |
---|
alias | Products |
---|
url | https://www.idera.com/productssolutions/sqlserver |
---|
| | Newtabfooter |
---|
alias | Purchase |
---|
url | https://www.idera.com/buynow/onlinestore |
---|
| | Newtabfooter |
---|
alias | Support |
---|
url | https://idera.secure.force.com/ |
---|
| | Newtabfooter |
---|
alias | Community |
---|
url | http://community.idera.com |
---|
| | Newtabfooter |
---|
alias | Resources |
---|
url | http://www.idera.com/resourcecentral |
---|
| | Newtabfooter |
---|
alias | About Us |
---|
url | http://www.idera.com/about/aboutus |
---|
| | Newtabfooter |
---|
alias | Legal |
---|
url | https://www.idera.com/legal/termsofuse |
---|
|
|