Audit Database Changes in the Real World

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by tjaybelt » Audit Database Changes in the Real World

42 posts, Page 1 of 5

1 2 3 4 5 »»»

Audit Database Changes in the Real World

Rate Topic

Display Mode

Topic Options

Author

Message

tjaybelt

Posted Tuesday, June 10, 2008 11:26 PM

SSChasing Mays

Group: General Forum Members
Last Login: Sunday, May 19, 2013 9:17 AM
Points: 604, Visits: 379

Comments posted to this topic are about the item Audit Database Changes in the Real World

Post #514937

Anipaul

Posted Wednesday, June 11, 2008 1:33 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 4,787, Visits: 1,336

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

Bombardier

Posted Wednesday, June 11, 2008 4:19 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, February 05, 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

tonyf

Posted Wednesday, June 11, 2008 5:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 5:59 PM
Points: 4, Visits: 43

Why do all these articles assume that the DBA can be trusted?

Post #515071

Grant Fritchey

Posted Wednesday, June 11, 2008 5:48 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 13,378, Visits: 25,163

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #515087

Ian Massi

Posted Wednesday, June 11, 2008 6:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 12:15 PM
Points: 1,303, Visits: 1,664

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

Jack Corbett

Posted Wednesday, June 11, 2008 7:08 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

Preet_S

Posted Wednesday, June 11, 2008 8:06 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:15 AM
Points: 236, Visits: 235

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

msbasssinger

Posted Wednesday, June 11, 2008 8:30 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 08, 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

tjaybelt

Posted Wednesday, June 11, 2008 8:36 AM

SSChasing Mays

Group: General Forum Members
Last Login: Sunday, May 19, 2013 9:17 AM
Points: 604, Visits: 379

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 »

42 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions