rajib (12/23/2008)
I am curious to find out what your team does when it comes to database audit?Here are a list of questions from me:
- Do you check schema only to make sure it conforms to best practice?
- Do you check data against business rules?
- Do you perform any standard check on function and stored procedures?
I would like to hear more on this from this community.
Thanks
Actually, if you haven't been doing those 3 things all along, you're likely in deep trouble in all 3 areas. 😉
For an "accounting" or SEC audits, you need to have proof that you've been doing all 3 of those all along as well as proving that theres a viable audit trail for changes in the DDL, DML, or the data itself.
--Jeff Moden
Change is inevitable... Change for the better is not.