SQL Server Audit Log Event ID 24000

SourceSQL Server (LOGbinder SQL)
Action GroupNot applicable
Windows Security Log
Category
 • Subcategory
Object Access
 • Application Generated
Type Success

24000: SQL audit event

This is an event from SQL Server audit event from LOGbinder SQL generated by Action Group  Not applicable.

On this page

Undocumented SQL audit event

Free Security Log Resources by Randy

Description Fields in 24000

FieldDescription
OccurredWhen event was reported by SQL Server
ActionID of the SQL Audit Action. See sys.dm_audit_actions on TechNet.
Succeeded"True" or "False"
Permission bitmaskWhen applicable, shows the permissions that were granted, denied, or revoked
Is column permissionFlag indicating a column level permission
Session IDID of the session on which the event occurred
Server principal IDID of the login context that the action is performed in.
Database principal IDCurrent user
Target server principal IDTarget login of the action
Target database principal IDDatabase principal that the auditable action applies to.
Object IDThe primary ID of the entity on which the audit occurred. This includes: server objects, databases, database objects or schema objects
Class typeType of auditable entity that the audit occurs on. See SQL Server Audit Records on TechNet.
Session server principal nameServer principal for the session
Server principal nameCurrent Login
Server principal SIDCurrent login SID
OccurredWhen event was reported by SQL Server
Database principal nameCurrent user
Target server principal nameTarget login of the action
Target server principal SIDTarget login's SID of the action
Target database principal nameDatabase principal that the auditable action applies to.
Server instance nameName of the server instance where the audit occurred. Uses the standard machine\instance format.
Database nameDatabase affected by the event
Schema nameSchema context in which the action occurred
Object nameName of the entity on which the audit occurred. This includes: server objects, databases, database objects or schema objects
StatementTransact-SQL statement
Additional informationAny additional information about the event, stored as XML.

Supercharger Free Edition


Supercharger's built-in Xpath filters leave the noise behind.

Free.

 

Where Does This Event Come From?

This Event Is Produced By

Which Integrates with Your SIEM

 

Upcoming Webinars
    Additional Resources

      Go To Event ID:

      Security Log
      Quick Reference
      Chart
      Download now!