SQL Server Audit Log Event ID 24319
24319: A column master key was viewed (action_id VW; class_type CM)
This is an event from
SQL Server
audit event from
LOGbinder SQL
generated by
.
On this page
A column was issued that included viewing master key
Free Security Log Resources by Randy
| Field |
Description |
| Occurred |
When event was reported by SQL Server. |
| Authorization result |
If the command passed authorization checks. |
| Session ID |
ID of the session on which the event occurred. |
| User |
User |
| Server |
Server |
| Database |
Database affected by the event. |
| Statement |
Transact-SQL statement |
Setup PowerShell Audit Log Forwarding in 4 Minutes
This Event Is Produced By
Which Integrates with Your SIEM
A column master key was viewed
A column was issued that included viewing master key
Action Group: DATABASE_OBJECT_CHANGE_GROUP
Occurred: 11/7/2016 8:54:49.0000000 PM
Authorization result: Access allowed
Session ID: 141
User: TEST\STAGING$
Server: STAGING\SQLSERVER2016
Database: ReportServer$SQLSERVER2016
Statement: select db_id() as database_id, COUNT_BIG(*) AS ColumnMasterKeyCount, key_store_provider_name AS KeyStoreProviderName FROM sys.column_master_keys WITH(nolock) group by key_store_provider_name
For more information, see http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=24319
Top 10 Windows Security Events to Monitor
Free Tool for Windows Event Collection