Post reply

Tools/mechanism to audit SELECT statement

  • October 10, 2005 at 2:54 am

    #363916

    Hi all,

    I would like to be able to audit SELECT statements. I've read about FGA in Oracle 9i and up, but I'm wondering what other approaches/tools exist. Primarily the whole thing is for Oracle, but might be extented to MSSQL for instance.

    Is there something like an "Audit-Proxy" which sits between the client and the server, parses the network traffic for particular SQL statements and logs them somewhere. Just wonder what technics for SELECT audits are available.

    Thank you,

    Thomas

  • October 11, 2005 at 2:56 am

    #596469

    1. Deny all access to DB's except via SP's.

    2. Include in all SP's functionality that log's their own actions....to a text file or to a table 'outside the scope of a rollback transaction', possibly with a dynamic "turn logging on/off switch".

    Otherwise....turn PROFILER on permanently...and watch your performance go west.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply