Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Returns a row for every audit action that can be reported in the audit log and every audit action group that can be configured as part of SQL Server Audit. For more information about SQL Server Audit, see SQL Server Audit (Database Engine).
| Column name | Data type | Nullable | Description |
|---|---|---|---|
action_id |
varchar(4) | Yes | ID of the audit action. Related to the action_id value written to each audit record. Can be NULL for audit groups. |
name |
nvarchar(128) | No | Name of the audit action or action group. |
class_desc |
nvarchar(35) | No | The name of the class of the object that the audit action applies to. Can be any one of the Server, Database, or Schema scope objects, but doesn't include Schema objects. |
covering_action_name |
nvarchar(128) | Yes | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
parent_class_desc |
nvarchar(35) | Yes | Name of the parent class for the object described by class_desc. Can be NULL if the class_desc is Server. |
covering_parent_action_name |
nvarchar(128) | Yes | Name of the audit action or audit group that contains the audit action described in this row. This value is used to create a hierarchy of actions and covering actions. |
configuration_level |
nvarchar(128) | Yes | Indicates that the action or action group specified in this row is configurable at the Group or Action level. Can be NULL if the action isn't configurable. |
containing_group_name |
nvarchar(120) | Yes | The name of the audit group that contains the specified action. Can be NULL if the value in name is a group. |
action_in_log |
bit | No | Indicates whether an action can be written to an audit log. Possible values:1 = Yes0 = No |
Permissions
This view is visible to the public.
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata visibility configuration.
Related tasks
- 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)
Related content
- 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_specifications (Transact-SQL)
- sys.database_audit_specification_details (Transact-SQL)
- sys.dm_server_audit_status (Transact-SQL)
- sys.dm_audit_class_type_map (Transact-SQL)
- Create a Server Audit and Server Audit Specification