Page History
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 | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
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
...