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 12345»»»

Audit Database Changes in the Real World Expand / Collapse
Author
Message
Posted Tuesday, June 10, 2008 11:26 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, September 11, 2014 4:44 PM
Points: 615, Visits: 443
Comments posted to this topic are about the item Audit Database Changes in the Real World


Post #514937
Posted Wednesday, June 11, 2008 1:33 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,375, Visits: 1,391
Nice one. The success of the thing totally depends on the DBA. He or she has to take out time to complete the documentation after implementing the changes. :)


Post #514985
Posted Wednesday, June 11, 2008 4:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 5, 2010 1:12 AM
Points: 14, Visits: 135
Nice Article,
I wish to set up a solution as the one that you explain.
I am interested to see the code which you have create to inspire me on SQL Server.
Thx.
Post #515042
Posted Wednesday, June 11, 2008 5:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 4, 2014 11:05 PM
Points: 5, Visits: 45
Why do all these articles assume that the DBA can be trusted?


Post #515071
Posted Wednesday, June 11, 2008 5:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
Excellent article TJ. Congratulations on a well ordered process.

Any chance of posting the code for the procs that start the traces? I'm curious about some of the details of how you did that.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #515087
Posted Wednesday, June 11, 2008 6:20 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 1:51 PM
Points: 1,597, Visits: 1,927
A very nice integration of SOX with your change control process. I especially liked step 11 with the yelling and finger pointing. I certainly hope that this is documented for the auditors as part of the official process.
Post #515103
Posted Wednesday, June 11, 2008 7:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:45 AM
Points: 10,206, Visits: 13,153
Grant Fritchey (6/11/2008)
Excellent article TJ. Congratulations on a well ordered process.

Any chance of posting the code for the procs that start the traces? I'm curious about some of the details of how you did that.


I second the comment and the question. It would be nice to have the scripts for all the objects.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #515141
Posted Wednesday, June 11, 2008 8:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 20, 2013 4:45 AM
Points: 236, Visits: 239
msbasssinger (6/11/2008)
I think I have a less complicated approach to audit trails.


Isn't yours a different type of auditing i.e. changes to data as opposed to what the article is about (changes to database objects) ?
Post #515193
Posted Wednesday, June 11, 2008 8:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 8, 2012 7:33 AM
Points: 11, Visits: 75
Yes. I grabbed the wrong audit article. My bad, and my apologies.

Time to revist the coffee pot. :)
Post #515217
Posted Wednesday, June 11, 2008 8:36 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, September 11, 2014 4:44 PM
Points: 615, Visits: 443
tonyf (6/11/2008)
Why do all these articles assume that the DBA can be trusted?


In this articles case, i am the DBA, and of course i can be trusted...
Its a good point though. And a difficult one, when im the one creating the system to monitor myself. If there were more players in this puzzle, i would definitely defer to them to monitor me. But in my experience, it needed to be monitored prior to the other players coming on the field.
This is one way. Obviously other policies and procedures can be implemented to assume that distrust and more effectively safegaurd the systems against those untrustworthy DBA's



Post #515224
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse