Skip to content

sys-dm-audit-class-type-map-transact-sql.md

Latest commit

 

History

History
76 lines (63 loc) · 4.76 KB

sys-dm-audit-class-type-map-transact-sql.md

File metadata and controls

76 lines (63 loc) · 4.76 KB
title sys.dm_audit_class_type_map (Transact-SQL)
description sys.dm_audit_class_type_map returns a table that lists securable classes that can be mapped to the class_type column in the audit log.
author sravanisaluru
ms.author srsaluru
ms.reviewer randolphwest
ms.date 11/25/2024
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sys.dm_audit_class_type_map
sys.dm_audit_class_type_map_TSQL
dm_audit_class_type_map
dm_audit_class_type_map_TSQL
helpviewer_keywords
sys.dm_audit_class_type_map dynamic management view
dev_langs
TSQL
monikerRange =azuresqldb-current || >=sql-server-2016 || =azuresqldb-mi-current

sys.dm_audit_class_type_map (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi]

Returns a table that lists securable classes that can be mapped to the class_type column in the audit log. For more information about [!INCLUDE ssNoVersion] 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, [!INCLUDE sssql19-md] and earlier versions require CONTROL SERVER permission on the server, while [!INCLUDE sssql22-md] and later versions require VIEW SERVER SECURITY AUDIT permission on the server.

Examples

This [!INCLUDE ssnoversion-md] 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