Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Audit the Audit settings changes Expand / Collapse
Author
Message
Posted Thursday, May 16, 2013 8:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
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.
Post #1453591
Posted Tuesday, January 7, 2014 11:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:41 PM
Points: 1,392, Visits: 803
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.

[url=http://msdn.microsoft.com/en-us/library/cc280663(v=sql.110).aspx][/url]


Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)

Post #1528611
Posted Tuesday, January 7, 2014 11:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:41 PM
Points: 1,392, Visits: 803
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)

Post #1528612
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse