Auditing of SQLServer
-
Could someone please let me know what is the best way (or provide alernatives) for auditing specific DBA events,(i.e,adding, modifiying, deleting objects such as tables, etc). Also all grants, and adding, revoking logins and users. This is necessary due to an audit mandate that all DBA activities are recorded and available for management to view and run reports.
Any help would be appreciated,
Charles L. Nichols
Charles L. Nichols -
I would suggest you to look at third party products from http://www.lumigent.com.
-
-
Hi Charles,
quote:
Could someone please let me know what is the best way (or provide alernatives) for auditing specific DBA events,(i.e,adding, modifiying, deleting objects such as tables, etc). Also all grants, and adding, revoking logins and users. This is necessary due to an audit mandate that all DBA activities are recorded and available for management to view and run reports.well, it might be an overkill to what you want to achieve, but why not use SQL Server's built-in C2 auditing feature. There is some explanation on this in BOL. At least you don't have to buy a third-party tool
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
you can also make a table in SQL Server named MyAuditTable .. and make trigers on every table you have to add a record in your MyAuditTable when any data is added, modified, or deleted on evry table.
hope this help you.
Alamir Mohamed
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply