Versions Compared

Key

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

...

The Trusted Users tab of the SQL Database Default Audit Settings window allows you to add Trusted Users at database level and set the default audit settings. Trusted users are SQL Server logins and members of SQL Server roles that you trust to read, update, or manage a particular audited server or databases. 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. This exclusion occurs for all auditing, including DML and SELECT events related to sensitive columns and before and after data.

Image Removed


When you designate trusted users, consider limiting your list to a few specific logins. This approach optimizes event processing performance and ensures you filter the intended accounts.

If you are auditing privileged user activity and the trusted user is also a privileged user, IDERA SQL Compliance Manager will continue to audit this user because of its elevated privileges. For example, a service account that is a member of the sysadmin fixed SQL Server role will continue to be audited even though the account is designated as trusted. Keep in mind that trusted users are filtered at the database level whereas privileged users are audited at the server level.
To omit, or filter, events generated by specific logins and roles from your audit data trail, select the SQL Server login or role you want to trust and click Add.

Image Added

Available actions

...

Available actions

Add

Allows you to select add one or more privileged users to audit. You can select add privileged users by Server Roles or by Server Logins.

...