sys.server_audit_specification_details (Transact-SQL)
Contains information about the server audit specification details (actions) in a SQL Server audit on a server instance. For more information, see Understanding SQL Server Audit.
Column name |
Data type |
Description |
|---|---|---|
server_specification_id |
int |
ID of the audit server specification |
audit_action_id |
int |
ID of the audit action |
audit_action_name |
sysname |
Name of group or name of audit action |
class |
tinyint |
Reserved |
class_desc |
nvarchar(60) |
Reserved |
major_id |
int |
Reserved |
minor_id |
int |
Reserved |
audited_principal_id |
int |
Reserved |
audited_result |
nvarchar(60) |
Audited result: - SUCCESS AND FAILURE - SUCCESS - FAILURE |
is_group |
bit |
Whether the audited object is a group: 0 - Not a group 1 - Group |
Permissions
Principals with the VIEW AUDIT STATE permission have access to this catalog view.
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
See Also