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

Thread: How To Audit Unsucessful Access To Table

  1. #1
    Join Date
    Nov 2002
    Posts
    170

    How To Audit Unsucessful Access To Table

    Can someone tell me if I can audit any unsucessful access to tables.

    Eg. if SCOTT doesn't have access to table FIN.ACOUNT
    and he runs a query
    select * from fin.account
    where username='SCOTT';

    the stmt will fail.

    I want to capture the username i.e SCOTT and the date/time he tried to access.

    Is it possible thru Oracle AUDIT ? Oracle hasn't answer to this question...thought if anyone here has done this kind of auditing ?

  2. #2
    Join Date
    Nov 2002
    Posts
    170
    I got the answer. Thanks anyway

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