TRC_SECURITY_AUDIT

This event type or event group can be specified when you create Event Notifications to monitor and respond to activity in the database or server instance. Event notifications can be created directly in the SQL Server Database Engine or by using the WMI Provider for Server Events. Some events can also be used when you create DDL triggers. For more information, see Designing DDL Triggers.

Parent: TRC_ALL_EVENTS

Children: AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT, AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT, AUDIT_DATABASE_OBJECT_GDR_EVENT, AUDIT_CHANGE_AUDIT_EVENT, AUDIT_BACKUP_RESTORE_EVENT, AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT, AUDIT_LOGOUT, AUDIT_CHANGE_DATABASE_OWNER, AUDIT_ADD_ROLE_EVENT, AUDIT_SERVER_OPERATION_EVENT, AUDIT_SCHEMA_OBJECT_GDR_EVENT, AUDIT_DATABASE_OPERATION_EVENT, AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT, AUDIT_SCHEMA_OBJECT_ACCESS_EVENT, AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT, AUDIT_SERVER_ALTER_TRACE_EVENT, AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT, AUDIT_LOGIN_CHANGE_PROPERTY_EVENT, AUDIT_DATABASE_OBJECT_ACCESS_EVENT, AUDIT_DATABASE_MANAGEMENT_EVENT, AUDIT_LOGIN_GDR_EVENT, AUDIT_LOGIN_FAILED, AUDIT_LOGIN, AUDIT_LOGIN_CHANGE_PASSWORD_EVENT, AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT, AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT, AUDIT_ADDLOGIN_EVENT, AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT, AUDIT_DBCC_EVENT, AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT, AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT, AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT, AUDIT_SERVER_OBJECT_GDR_EVENT, AUDIT_DATABASE_SCOPE_GDR_EVENT, AUDIT_ADD_DB_USER_EVENT, AUDIT_SERVER_SCOPE_GDR_EVENT, AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT

Properties

Inherited from Parents

Event Properties