sys-database-audit-specifications-transact-sql.md

title	sys.database_audit_specifications (Transact-SQL)
description	sys.database_audit_specifications (Transact-SQL)
author	sravanisaluru
ms.author	srsaluru
ms.reviewer	rwestMSFT
ms.date	04/04/2022
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	database_audit_specifications_TSQL sys.database_audit_specifications_TSQL sys.database_audit_specifications database_audit_specifications
helpviewer_keywords	sys.database_audit_specifications catalog view
dev_langs	TSQL

sys.database_audit_specifications (Transact-SQL)

[!INCLUDE SQL Server]

This article contains information about the database audit specifications in a [!INCLUDEssNoVersion] audit on a server instance. For more information, see SQL Server Audit (Database Engine).

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.
modify_date	datetime	Date the audit specification was last modified.
audit_guid	uniqueidentifier	GUID for the audit that contains this specification. Used during enumeration of member database audit specifications during database attach/startup.
is_state_enabled	bit	Audit specification state: 0 - DISABLED 1 - ENABLED

Remarks

If a database is in ready-only mode, the [!INCLUDEssNoVersion] Audit feature can't add Database Audit Specifications.

Permissions

Principals with the ALTER ANY DATABASE AUDIT or VIEW DEFINITION permissions, the dbo role, and members of the db_owners fixed database role have access to this catalog view. In addition, the principal must not be denied VIEW DEFINITION permission.

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See also

• CREATE SERVER AUDIT (Transact-SQL)
• ALTER SERVER AUDIT (Transact-SQL)
• DROP SERVER AUDIT (Transact-SQL)
• CREATE SERVER AUDIT SPECIFICATION (Transact-SQL)
• ALTER SERVER AUDIT SPECIFICATION (Transact-SQL)
• DROP SERVER AUDIT SPECIFICATION (Transact-SQL)
• CREATE DATABASE AUDIT SPECIFICATION (Transact-SQL)
• ALTER DATABASE AUDIT SPECIFICATION (Transact-SQL)
• DROP DATABASE AUDIT SPECIFICATION (Transact-SQL)
• ALTER AUTHORIZATION (Transact-SQL)
• sys.fn_get_audit_file (Transact-SQL)
• sys.server_audits (Transact-SQL)
• sys.server_file_audits (Transact-SQL)
• sys.server_audit_specifications (Transact-SQL)
• sys.server_audit_specification_details (Transact-SQL)
• sys.database_audit_specification_details (Transact-SQL)
• sys.dm_server_audit_status (Transact-SQL)
• sys.dm_audit_actions (Transact-SQL)
• sys.dm_audit_class_type_map (Transact-SQL)
• Create a Server Audit and Server Audit Specification