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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy