sys.server_audit_specification_details (Transact-SQL)sys.server_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 server audit specification details (actions) in a SQL ServerSQL Server audit on a server instance. 有关详细信息,请参阅 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
server_specification_idserver_specification_id intint 审核服务器规范的 IDID of the audit server specification
audit_action_idaudit_action_id intint 审核操作的 IDID of the audit action
audit_action_nameaudit_action_name sysnamesysname 组名称或审核操作名称Name of group or name of audit action
classclass tinyinttinyint 预留Reserved
class_descclass_desc nvarchar(60)nvarchar(60) 预留Reserved
major_idmajor_id intint 预留Reserved
minor_idminor_id intint 预留Reserved
audited_principal_idaudited_principal_id intint 预留Reserved
audited_resultaudited_result nvarchar(60)nvarchar(60) 审核结果:Audited result:

- SUCCESS AND FAILURE- SUCCESS AND FAILURE

- SUCCESS- SUCCESS

- FAILURE- FAILURE
is_groupis_group bitbit 审核对象是否为组:Whether the audited object is a group:

0 - 不是组0 - Not a group

1 - 组1 - Group

权限Permissions

具有 ALTER ANY SERVER AUDITVIEW any DEFINITION 权限的主体有权访问此目录视图。Principals with the ALTER ANY SERVER AUDIT or VIEW ANY DEFINITION permission have access to this catalog view. 此外,不能拒绝主体 VIEW ANY DEFINITION 权限。In addition, the principal must not be denied VIEW ANY 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

安全性目录视图 (Transact-SQL) Security Catalog Views (Transact-SQL)
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.database_audit_specifications (Transact-SQL) sys.database_audit_specifications (Transact-SQL)
sys.database_audit_specification_details (Transact-SQL) sys.database_audit_specification_details (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