sys.database_audit_specification_details (Transact-SQL)sys.database_audit_specification_details (Transact-SQL)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions)

包含所有数据库的服务器实例上 SQL ServerSQL Server 审核中的数据库审核规范的相关信息。Contains information about the database audit specifications in a SQL ServerSQL Server audit on a server instance for all databases. 有关详细信息,请参阅 SQL Server Audit(数据库引擎)For more information, see SQL Server Audit (Database Engine). 有关所有 audit_action_id 及其名称的列表,请查询 dm_audit_actions sys.databases (transact-sql)For a list of all audit_action_id's and their names, query sys.dm_audit_actions (Transact-SQL).

列名称Column name 数据类型Data type 说明Description
database_specification_iddatabase_specification_id intint 审核规范的 ID。ID of the audit specification.
audit_action_idaudit_action_id intint 审核操作的 ID。ID of the audit action.
audit_action_nameaudit_action_name SysnameSysname 审核操作或审核操作组的名称Name of audit action or audit action group
Class intint 标识要审核的对象的类型。Identifies class of object which is being audited.
class_ descclass_ desc **Nvarchar (60) **Nvarchar(60) 正审核的对象的类的说明:Description of class of object which is being audited:

- SCHEMA- SCHEMA

- TABLE- TABLE
major_idmajor_id intint 正审核的对象的主 ID,如表审核操作的表 ID。Major ID of object being audited, such as a Table ID of a Table Audit action.
minor_idminor_id IntInt 正审核的对象的辅助 ID(如表审核操作的列 ID),根据类进行解释。Secondary ID of object that is being audited, interpreted according to class, such as the column ID of a Table Audit action.
audited_principal_idaudited_principal_id intint 正审核的主体。Principal that is being audited.
audited_resultaudited_result **Nvarchar (60) **Nvarchar(60) 审核操作的结果:Audit action results:

- SUCCESS AND FAILURE - SUCCESS- SUCCESS AND FAILURE - SUCCESS

- FAILURE- FAILURE
is_groupis_group bitBit 显示该对象是否为组:Shows whether the object is a group:

0 - 不是组0 - Not a group

1 - 组1 - Group

权限Permissions

具有 ALTER ANY DATABASE AUDITVIEW DEFINITION 权限的主体、 dbo 角色和 db_owners 固定数据库角色的成员都有权访问此目录视图。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. 此外,不能拒绝主体 VIEW DEFINITION 权限。In addition, the principal must not be denied VIEW DEFINITION permission.

目录视图中仅显示用户拥有的安全对象的元数据,或用户对其拥有某些权限的安全对象的元数据。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. 有关详细信息,请参阅 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

另请参阅See Also

CREATE SERVER AUDIT (Transact-SQL) CREATE SERVER AUDIT (Transact-SQL)
ALTER SERVER AUDIT (Transact-SQL) ALTER SERVER AUDIT (Transact-SQL)
DROP SERVER AUDIT (Transact-SQL) DROP SERVER AUDIT (Transact-SQL)
CREATE SERVER AUDIT SPECIFICATION (Transact-SQL) CREATE SERVER AUDIT SPECIFICATION (Transact-SQL)
ALTER SERVER AUDIT SPECIFICATION (Transact-SQL) ALTER SERVER AUDIT SPECIFICATION (Transact-SQL)
DROP SERVER AUDIT SPECIFICATION (Transact-SQL) DROP SERVER AUDIT SPECIFICATION (Transact-SQL)
CREATE DATABASE AUDIT SPECIFICATION (Transact-SQL) CREATE DATABASE AUDIT SPECIFICATION (Transact-SQL)
ALTER DATABASE AUDIT SPECIFICATION (Transact-SQL) ALTER DATABASE AUDIT SPECIFICATION (Transact-SQL)
DROP DATABASE AUDIT SPECIFICATION (Transact-SQL) DROP DATABASE AUDIT SPECIFICATION (Transact-SQL)
ALTER AUTHORIZATION (Transact-SQL) ALTER AUTHORIZATION (Transact-SQL)
sys.fn_get_audit_file (Transact-SQL) sys.fn_get_audit_file (Transact-SQL)
sys.server_audits (Transact-SQL) sys.server_audits (Transact-SQL)
sys.server_file_audits (Transact-SQL) sys.server_file_audits (Transact-SQL)
sys.server_audit_specifications (Transact-SQL) sys.server_audit_specifications (Transact-SQL)
sys.server_audit_specification_details (Transact-SQL) sys.server_audit_specification_details (Transact-SQL)
sys.database_audit_specifications (Transact-SQL) sys.database_audit_specifications (Transact-SQL)
sys.dm_server_audit_status (Transact-SQL) sys.dm_server_audit_status (Transact-SQL)
sys.dm_audit_actions (Transact-SQL) sys.dm_audit_actions (Transact-SQL)
sys.dm_audit_class_type_map (Transact-SQL) sys.dm_audit_class_type_map (Transact-SQL)
创建服务器审核和服务器审核规范Create a Server Audit and Server Audit Specification