These pages cover SQL Monitor 5, which is not the latest version. Help for other versions is also available.

User role restrictions

This pages lists the restrictions on standard and read-only user roles. Administrators have no restrictions.

  • If you configure SQL Monitor to authenticate with Active Directory, you can also restrict which individual servers and groups users have access to.
  • The read-only user role is not available if you use Active Directory authentication.

 

Standard users

Read-only users

(not available if you use Active Directory authentication)

Overview

(tick) No restrictions

(tick) No restrictions

Alert inbox

(tick) No restrictions

(warning) Can't:

  • save custom filters
  • select multiple alerts
  • mark alerts as cleared or uncleared
  • mark alerts as read or unread
  • add comments

Analysis page

(tick) No restrictions

(tick) No restrictions

Configuration >
Monitored servers

(warning) Can't:

  • add servers to monitor
  • edit credentials
  • remove servers

(warning) Can't:

  • add servers to monitor
  • edit credentials
  • remove servers
  • show logs
  • set maintenance windows
  • suspend monitoring
  • select servers

Configuration >
Trace

(warning) Can't:

  • turn trace settings on or off
  • save trace settings

(warning) Can't:

  • turn trace settings on or off
  • save trace settings

Configuration >
Groups

(warning) Can't create, rename, select, move or delete groups

(warning) Can't create, rename, select, move or delete groups

Configuration >
Data purging

(warning) Can't edit or save changes to purge settings

(warning) Can't edit or save changes to purge settings

Configuration >
Manage user roles

(error) No access

(error) No access

Configuration >
Base monitor
connection

(error) No access

(error) No access

Configuration >
Alert settings

(tick) No restrictions

(warning) Can't:

  • select multiple alerts
  • configure alerts
  • remove overrides

Configuration >
Alert settings >
Alert page

(tick) No restrictions

(warning) Can't configure alert changes

Configuration >
Email settings

(warning) Can't configure email settings

(warning) Can't configure email settings

Configuration >
Custom metrics

(error) No access(error) No access

Configuration >
Licensing

(error) No access

(error) No access

Configuration >
About

(tick) No restrictions

(tick) No restrictions


Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?