sys.server_audit_specifications (Transact-SQL)sys.server_audit_specifications (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 Server 审核中的服务器审核规范的信息。Contains information about the server audit specifications in a SQL Server audit on a server instance. 有关 SQL Server Audit 的详细信息,请参阅 SQL Server Audit(数据库引擎)For more information on SQL Server Audit, see SQL Server Audit (Database Engine).

列名称Column name 数据类型Data type 说明Description
name name SysnameSysname 服务器规范的名称。Name of the server specification.
server_specification_idserver_specification_id IntInt Server_specification的 ID。ID of the server_specification.
create_datecreate_date 日期时间Datetime 审核服务器规范的创建日期。Date the audit server specification was created.
modified_datemodified_date 日期时间Datetime 审核服务器规范的上次修改日期。Date the audit server specification was last modified.
is_state_enabledis_state_enabled tinyinttinyint 审核规范状态:Audit specification state:

0-已禁用0 - DISABLED

1-已启用1 -ENABLED
audit_GUIDaudit_GUID uniqueidentifieruniqueidentifier 包含此规范的审核的 GUID。GUID for the audit that contains this specification. 在服务器启动期间成员服务器审核规范的枚举过程中使用。Used during enumeration of member server audit specifications during server startup.

权限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

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_specification_details (Transact-SQL) sys.server_audit_specification_details (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