-
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 ?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|