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

Thread: audit on table

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    audit on table

    hi

    i ran this command at my SQL :
    SQL> AUDIT SELECT ON HIEM_EMP WHENEVER NOT SUCCESSFUL;

    Audit succeeded.

    now i want to see the audit data, like how many time select was unsuccessful, on the table.
    so where should i look for it. is there any data dictionary for that.

    thanx
    binoy

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    sys.aud$
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Nov 2005
    Posts
    32
    hi
    check dba_audit_trail table

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