Page History

To monitor an Amazon RDS instance using SQL Diagnostic Manager, you have to create a SQL Server user on the instance with the following minimum permissions:

Server Roles

...

• public

...

• processadmin

...

• setupadmin

Databases

...

• public on TempDB
• sysadmin server role equivalent privileges for monitored databases

...

Securable

Server Object:

...

• Alter any connection
• Alter any linked server
• Alter any login

...

• Alter any

...

• server

...

• role
• Alter server state
• Alter trace
• Connect SQL
• Create any database
• Create server role
• View any database

...

• View any definition

...

• View

...

• server state

...