Hi,
We need to capture all the activity in SQL database, for auditing purposes.
Can we audit the activity inside the Katmai to capture SELECTs activity?
Remember that this is for auditing purposes.
Regards,
At the moment, the 2008 June CTP has change data capture (http://blog.benhall.me.uk/2007/06/sql-server-2008-change-data-capture-cdc.html) which audits all the changes made to a table stucture and inserts,updates,deletes from tables.
In a future CTP, I've read auditing of SELECT statements will be included. Sadly, I am not sure when this is planned for.
Hope this helps.
Ben
CDC wasn' designed for auditing so it most likely won't meet your needs as most auditing scenarios require capturing who logged the change as well.
I would look in two possible direction to do this with SQL2000 or SQL2005:
a) using profiler, you can catch al the info you need. You just have to filter just what you need and structure it for easy reporting
b) I was about to say you should look at what C2 Auditinf has to offer, but it seem it has been changed to Common Criteria. Look in the BOL or here: http://www.microsoft.com/sql/commoncriteria/2005/sp1/default.mspx
We do plan to provide auditing support in SQL Server 2008. However, the feature is not available in SQL Server 2008 July CTP. Expect to see it in a future CTP.
I have seen some suggestions on this thread to use Change Data Capture (CDC) for auditing purposes. As Greg has already mentioned, CDC is not designed for auditing and most likely will not meet auditing needs.
For more on CDC vs. Auditing, take a look at the following thread on this forum: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1730222&SiteID=1
