Export (0) Print
Expand All

sys.database_audit_specifications (Transact-SQL)

Contains information about the database audit specifications in a SQL Server audit on a server instance. For more information, see Understanding SQL Server Audit.

Column name

Data type

Description

Name

sysname

Name of the auditing specification.

database_specification_id

int

ID of the database specification.

create_date

datetime

Date the audit specification was created.

modified_date

datetime

Date the audit specification was last modified.

is_state_enabled

bit

Audit specification state:

0 – ENABLED

1 – DISABLED

audit_GUID

uniqueidentifer

GUID for the audit that contains this specification. Used during enumeration of member database audit specifications during database attach/startup.

If a database is in ready-only mode, the SQL Server Audit feature cannot add Database Audit Specifications.

Principals with the VIEW AUDIT STATEorALTER ANY AUDIT SPECIFICATION permissions, the dbo role, and members of the db_owners fixed database role 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.

Community Additions

ADD
Show:
© 2015 Microsoft