Edit

Share via

sys.dm_audit_class_type_map (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

Returns a table that lists securable classes that can be mapped to the class_type column in the audit log. For more information about SQL Server Audit, see SQL Server Audit (Database Engine).

Column name Data type Description
class_type char(2) The class type of the entity that was audited. Maps to the class_type written to the audit log returned by the get_audit_file() function. Isn't nullable.
class_type_desc nvarchar(120) The name of the class of the object that was audited. Isn't nullable.
securable_class_desc nvarchar(120) The securable class that maps to the class_type being audited. NULL if the class_type doesn't map to a securable object. Can be joined with class_desc in sys.dm_audit_actions.

Permissions

This view is visible to the public.

To use the sys.fn_get_audit_file function, SQL Server 2019 (15.x) and earlier versions require CONTROL SERVER permission on the server, while SQL Server 2022 (16.x) and later versions require VIEW SERVER SECURITY AUDIT permission on the server.

Examples

This SQL Server example reads a locally stored Audit file and joins it with the sys.dm_audit_class_type_map view.

SELECT *
FROM sys.fn_get_audit_file('D:\SQLData\Audits\*.sqlaudit', DEFAULT, DEFAULT) AS audit_file
     INNER JOIN sys.dm_audit_class_type_map AS dm_audit_class_type_map
         ON audit_file.class_type = dm_audit_class_type_map.class_type;
GO

Transact-SQL reference

Related content