Versions Compared

Key

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

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


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