Versions Compared

Key

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

Trusted

...

 Trusted users are SQL Server logins and members of SQL Server roles that you trust to read, update, or manage a particular audited database. The SQL Compliance Manager Agent removes events generated by trusted users from the audit trail before sending the trace file to the Collection Server for processing.

...

To omit, or filter, events generated by specific logins and roles from your audit data trail, click Add, and then select the SQL Server login or role you want to trust.

Available actions

 Add a trusted user or role 

Allows you to select which SQL Server logins or roles you want to trust on this database. When a login or role is designated as trusted, the SQLcompliance Agent omits all database-level activity generated by these logins from the audit data trail.

Remove a user or role from the trusted list 

Allows you to designate a previously trusted SQL Server login or role as non-trusted. When a login or role becomes non-trusted, SQL CM begins auditing database-level activity generated by this login or role, based on your current audit settings.

 

SQL Compliance Manager audits all activity on your server. Learn more > >