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
  • Track and stop tracking queries

(warning) Can't:

  • See query plan parameters
  • Track and stop tracking queries

(warning) Can't:

  • See query plan parameters
  • Track and stop tracking queries
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

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

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

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

Virtualization

(error) No access

(error) No access

(error) No access

Manage user roles

(error) No access

(error) No access

(error) No access

Authentication

(error) No access

(error) No access

(error) No access

Base Monitor
connection

(error) No access

(error) No access

(error) No access

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

Alert settings >
Alert page

(tick) No restrictions

(warning) Can't configure alert changes

(warning) Can't configure alert changes

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

Notification settings

(error) No access

(error) No access

(error) No access

Display settings

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

Custom metrics

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

Licensing

(error) No access

(error) No access

(error) No access

About

(error) No access

(error) No access

(error) No access

Retrieve log files

(error) No access

(error) No access

(error) No access

Error reporting

(error) No access

(error) No access

(error) No access

API Authentication tokens

(error) No access

(error) No access

(error) No access

API Download

(error) No access

(error) No access

(error) No access

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?