May 16, 2013 at 8:48 am
I have a requirement from my customer to enable auditing, few at the server level and few at the database level.
I have been successful in enabling the audit.
Now, I have a question of we can audit the changes in the auditing configuration itself?
For example..If someone deletes a particular setting in the audit properties, I want that to get logged too.
Is it possible.
January 7, 2014 at 11:27 am
I realize this is an old post, but ran across it working on a SQL Audit issue myself
For any future reference:
Look for the Server-Level Audit Action Group - AUDIT_CHANGE_GROUP
This event is raised whenever any audit is created, modified or deleted. This event is raised whenever any audit specification is created, modified, or deleted. Any change to an audit is audited in that audit.
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
January 7, 2014 at 11:35 am
Furthermore, a great feature...
When a change to and Audit or Audit Specification are attempted, the Audit or Audit Specification must be DISABLED to make that change.
That DISABLE and ENABLE (after the change) is also automatically Audited
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply