Page History
The Alerting option from the SQL Compliance Manager Menu allows users to configure their preferred email and SNMP settings, as well as to groom undesired alerts on your SQL Servers. Privileged/Trusted Users report lists all trusted and privileged users set in each server instance and database. Use this report to monitor which Trusted and Privileged Users were set to during a snapshot in time.
A filter can include a list of wildcards, separated by commas, where a wildcard is a string, which may contain asterisks. The following parameters are specific to the selected report and enable you to filter the data to include in the report.(screenshot)
Available actions
Server Instance
The
Databases
Login
User Type
Trusted, Privileged or Both
Available fields
...
Allows you to select a registered instance on which you want to report. Select ALL to report on all instances.
Databases
Allows you to select or type the name of one or more databases on which you want to report.
Login
Allows you to select the login from the drop down list of available logins. Select ALL to report on all logins.
Role
Allows you to define the type of role for which you want this report to filter on. Select one of the Roles to filter the report on from the drop down menu option.
User Type
Allows you to select the type of user for which you want this report to filter on. Select between the following options; Both, Trusted or Privileged.
Default columns
Logins/Roles
The Logins/Roles column displays the name of the login or role.
Server/Database
The Server/Database column displays the name of the server or database.
...