|
|
|
Mr or Mrs. 500
 
Group: General Forum Members
Last Login: Monday, November 16, 2009 2:55 PM
Points: 536,
Visits: 198
|
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Thursday, November 12, 2009 7:14 AM
Points: 3,295,
Visits: 964
|
|
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. :)
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 5:59 AM
Points: 14,
Visits: 132
|
|
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.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, July 29, 2009 7:45 PM
Points: 3,
Visits: 35
|
|
Why do all these articles assume that the DBA can be trusted?
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Tuesday, November 17, 2009 8:32 PM
Points: 6,799,
Visits: 13,363
|
|
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 2008 Query Performance Tuning Distilled
For better & quicker help read:
How to Post Performance Problems
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Yesterday @ 10:18 AM
Points: 605,
Visits: 853
|
|
| 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.
|
|
|
|
|
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 7,471,
Visits: 7,029
|
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, November 09, 2009 10:20 AM
Points: 184,
Visits: 143
|
|
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) ?
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Friday, November 13, 2009 6:18 AM
Points: 11,
Visits: 72
|
|
Yes. I grabbed the wrong audit article. My bad, and my apologies.
Time to revist the coffee pot. :)
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, November 16, 2009 2:55 PM
Points: 536,
Visits: 198
|
|
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
|
|
|
|
