Re: SQL 2005 - audit SELECT statements?

Joe wrote:
Hi!

Any ideas on how to audit *select* statements with SQL 2005?

This is a pretty common requirement with databases where one needs to
keep track of who-saw-what.
Oracle has had it for ages... wasn't able to find it anywhere for sql
2005... but need the functionallity.

Regards,

Joe

My recommendation would be to require all users access data through a defined set of stored procedures. You can audit access to those stored procedures you need audit simply by logging access to the procedure in an audit table.

--
David Gugick - SQL Server MVP
Quest Software

.

Relevant Pages

  • sql CLR trigger causing havoc in Access linked table
    ... Excuse if this is not the correct group -- I am not using an adp, but an upsized mdb file with linked tables. ... Have been running an Access front end on a SQL Server back end for several years. ... However, when the CLR trigger fires, SQL returns the ID of the row from the audit table, not the table where the original insert occurred. ... The new record still gets inserted correctly; the trigger fires correctly; the problem is solely how Access represents the current/new record. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Problems launching DTS package from Stored Procedure
    ... exec sp_bcp_dbcmptlevel "UsersDatabase" SET FMTONLY ON Select * from Users1 ... Audit Logout ... Here is an example of an UNSUCCESSFUL sql profiler log: ... > I cannot run enterprise manager on our server because it is not installed. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sql Profiler trace file converted to a table
    ... 'Login Failed') ... 'SQL Transaction') ... 'CursorPrepare') ... 'Audit Statement GDR') ...
    (microsoft.public.sqlserver.security)
  • Re: file backup component
    ... I've gotten my problem solved.The reason why my SQL service sometimes can ... Otherwise you can try to use audit techniques to find out who's trying to ... file backup app or any other app that need LDF file a while. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Best way to clear stale data from very active audit tables
    ... has a bunch of audit style tables. ... We're experiencing significant ... our application can also run against sql server, which while fast, ... About partitions I can't offer any tips sorry... ...
    (comp.databases.oracle.server)