TechNet
Export (0) Print
Expand All

sys.dm_audit_actions (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 nameData typeDescription
action_idvarchar(4)ID of the audit action. Related to the action_id value written to each audit record. Is nullable. NULL for audit groups.
action_in_logbitIndicates whether an action can be written to an audit log. Values are as follows:

1 = Yes

0 = No
namesysnameName of the audit action or action group. Is not nullable.
class_descnvarchar(120)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 does not include Schema objects. Is not nullable.
parent_class_descnvarchar(120)Name of the parent class for the object described by class_desc. Is NULL if the class_desc is Server.
covering_parent_action_namenvarchar(120)Name of the audit action or audit group that contains the audit action described in this row. This is used to create a hierarchy of actions and covering actions. Is nullable.
configuration_levelnvarchar(10)Indicates that the action or action group specified in this row is configurable at the Group or Action level. Is NULL if the action is not configurable.
containing_group_namenvarchar(120)The name of the audit group that contains the specified action. Is NULL if the value in name is a group.

Principals must have SELECT permission. By default, this is granted to Public.

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.. For more information, see Metadata Visibility Configuration.

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_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

Community Additions

ADD
Show:
© 2016 Microsoft