Page History
...
| Data Type | Events Audited | Description |
|---|---|---|
| Logins |
| Audits login activity if an access check is performed and the event status is recorded (success or failure) at the server level |
| Administration |
| Audits common administrative tasks on the SQL Server instance |
| Security |
| Audits all SQL security model activity |
| Database Definition (DDL) |
| Audits create, drop, and alter operations performed on SQL Server objects, database objects, and schema object |
| DML | Object permissions | Audits common database operations, such as:
|
| Select | SELECT | Audits all SELECT statements executed on database table |
| Privileged User | All | Audits all privileged user activity at any level If the privileged user is also a trusted user , SQL Compliance Manager continues 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. |
| User defined | All | Audits all custom events generated using the sp_trace_generateevent stored procedure |
...