Versions Compared

Key

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

The Privileged User Auditing tab of the Registered SQL Server Properties window allows you to change the audit settings currently applied to privileged users on this SQL Server instance. You can choose to audit event categories and user-defined events. An event category includes related SQL Server events that occur at the server level. A user-defined event is a custom event you create and track using the the sp_trace_generateevent stored procedure.

...

Allows you to select one or more privileged users to audit. You can select privileged users by login name or by the membership to a fixed server role.

...

Allows you to remove the selected SQL Server login or fixed server role from the list of audited privileged users. When you remove the login or role, the SQL Compliance Manager Agent no longer collects events recorded for that login or the role members.

Note
titleNote

Any Privileged Users added at Server-level are automatically inherited and therefore disabled for selection at the Database Privileged User's settings. 

Available fields

Privileged users and roles to be audited

...

      • Logins
      • Logouts
      • Failed logins
      • Security changes
      • Administrative actions
      • Database definition (DDL)
      • Database modification (DML)
      • Database SELECT operations
      • User-defined events
      • Filter events based on access check.


Note
titleNote

Audited Activities configured at Server-level auditing are automatically pre-selected and disabled for selection for Privileged Users added at Server-level auditing. Users must edit changes at the Server-level audited activities tab to disable these settings. 


Capture SQL statements for DML and SELECT activities

...