SQL Monitor 11

User role restrictions

This pages list the restrictions on standard, reports 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.


Standard users

Reports users

Read-only users

Overview

(tick) No restrictions

(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

(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

(tick) No restrictions

Reports(tick) No restrictions(tick) No restrictions

(warning) Can't:

  • Create a new report
  • Edit or delete an existing report
Estate pages(tick) No restrictions(tick) No restrictions(tick) No restrictions
Server overview

(warning) Can't:

  • See query plan parameters

(warning) Can't:

  • See query plan parameters

(warning) Can't:

  • See query plan parameters

Configuration >
Monitored servers

(warning) Can't:

  • Add servers to monitor
  • Edit credentials
  • Remove servers
  • Set maintenance windows
  • Suspend monitoring

(warning) Can't:

  • Add servers to monitor
  • Edit credentials
  • Remove servers
  • Show logs
  • Set maintenance windows
  • Suspend monitoring
  • Select 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

(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

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

Configuration >
Data retention

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

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

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

Configuration >
Virtualization

(error) No access

(error) No access

(error) No access

Configuration >
Extended events

(error) No access

(error) No access

(error) No access

Configuration >
Manage user roles

(error) No access

(error) No access

(error) No access

Configuration >
Authentication

(error) No access

(error) No access

(error) No access

Configuration >
Base Monitor
connection

(error) No access

(error) No access

(error) No access

Configuration >
Alert settings

(tick) No restrictions

(warning) Can't:

  • Select multiple alerts
  • Configure alerts
  • Remove overrides

(warning) Can't:

  • Select multiple alerts
  • Configure alerts
  • Remove overrides

Configuration >
Alert settings >
Alert page

(tick) No restrictions

(warning) Can't configure alert changes

(warning) Can't configure alert changes

Configuration >
Alert suppression

(warning) Can't:

  • Create alert suppression windows
  • Edit alert suppression windows
  • Remove alert suppression windows

(warning) Can't:

  • Create alert suppression windows
  • Edit alert suppression windows
  • Remove alert suppression windows

(warning) Can't:

  • Create alert suppression windows
  • Edit alert suppression windows
  • Remove alert suppression windows

Configuration >
Notification settings

(error) No access

(error) No access

(error) No access

Configuration >
Display settings

(error) No access(error) No access(error) No access

Configuration >
Custom metrics

(error) No access(error) No access(error) No access

Configuration >
Licensing

(error) No access

(error) No access

(error) No access

Configuration >
About

(error) No access

(error) No access

(error) No access

Configuration >
Retrieve log files

(error) No access

(error) No access

(error) No access

Configuration >
Error reporting

(error) No access

(error) No access

(error) No access

Configuration >
API Authentication tokens

(error) No access

(error) No access

(error) No access

Configuration >
API Download

(error) No access

(error) No access

(error) No access

Configuration >
API Examples

(tick) No restrictions

(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?