DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: How to write audit trigger

Threaded View

  1. #9
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    FYI:

    Fine Grained Auditing (FGA) was introduced in Oracle9i, but it was limited to auditing queries. It was only in Oracle 10g that it could audit DML also. In addition, the SQL and bind values were not captured until Oracle 10g. As a result, it was of little use in Oracle9i, but it's really cool in Oracle 10g. I had a bunch of articles on auditing, but I've compiled them into one here:

    http://www.oracle-base.com/articles/...ained_auditing

    Cheers

    Tim...
    Last edited by TimHall; 02-16-2006 at 12:43 PM.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width