MS SQL Server Audit Event: 24318

MS SQL Server Auditing Tool

Databases are critical to enterprises because they store confidential data. Hence it becomes important to monitor database logs. But manually auditing them is a herculean task because of the enormous amount of log data generated. ManageEngine's EventLog Analyzer is a comprehensive log management tool that makes it easy for you to monitor all database activities, audit user accesses, track database server account changes, and ensure integrity of confidential data stored, especially in your MS SQL server database.

SQL » 24318: Issued a delete column master key command

24318: Issued a delete column master key command

Column master keys are used to encrypt column encryption keys. They must be stored in a trusted key store and must be accessible to applications that need to encrypt or decrypt data in the database. Event 24318 occurs when a command to create a column master key has been issued. It is generated by the DATABASE_OBJECT_CHANGE_GROUP action group. Important information can be derived from this event including the:

  • Date and time at which the event occurred.
  • Session identifier of the event.
  • Privileged user who performed the action.
  • Server and database associated with the event.