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 ?
