Export (0) Print
Expand All

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

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.

Updated content

Corrected the name of this catalog view from sys.database_audit_specifications_details to sys.database_audit_specification_details.

Community Additions

ADD
Show:
© 2014 Microsoft