February 24, 2016 at 2:07 am
Hello everyone.
Hoping someone could point me in the right direction , or offer some experienced advise.
I want to set up Database level auditing. Previously I used SQL traces with these events.
Event 102 Audit Statement GDR
Event 103 Audit Object GDR
Event 104 Audit Add/Drop Login
Event 105 Audit Login GDR
Event 106 Audit Login Change
Does anyone know what Database Audit Action types would meet the above requirements ?
Any body set up Database Audit Action and have any top tips on how to proceed ?
many thanks
February 24, 2016 at 5:39 am
DATABASE_PERMISSION_CHANGE_GROUP - Replaces Trace Event 102Audit Database Scope GDR Event
SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP - Replaces Trace Event 103Audit Schema Object GDR Event
SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 104Audit Addlogin Event
SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 106Audit Login Change Property Event
SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 105Audit Login GDR Event
I recently started looking at replacing the Trace I run on my servers with Audits, this page: https://msdn.microsoft.com/en-us/library/cc280663(v=sql.120).aspx is the best cross-reference you'll find. Just CTRL+F, key in the Trace event you're interested in, and get the equivalent Audit Specification.
February 24, 2016 at 5:44 am
jasona.work (2/24/2016)
DATABASE_PERMISSION_CHANGE_GROUP - Replaces Trace Event 102Audit Database Scope GDR EventSCHEMA_OBJECT_PERMISSION_CHANGE_GROUP - Replaces Trace Event 103Audit Schema Object GDR Event
SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 104Audit Addlogin Event
SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 106Audit Login Change Property Event
SERVER_PRINCIPAL_CHANGE_GROUP- Replaces Trace Event 105Audit Login GDR Event
I recently started looking at replacing the Trace I run on my servers with Audits, this page: https://msdn.microsoft.com/en-us/library/cc280663(v=sql.120).aspx is the best cross-reference you'll find. Just CTRL+F, key in the Trace event you're interested in, and get the equivalent Audit Specification.
Perfect , thanks for the reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply