I hate auditing!!!

Hi
I think I have far too much documentation to this simple audit and still isnt working....Im doing a simple test. Version 9.2.0 . audit_trail = DB . Restarted the instance.

Ran as sysdba
audit create any table by access;
audit drop any table by access;

As scott (a user)
create table t3 (a number);
drop table t3;

Shuldnt there be an entry in aud$ for dropping the table t3? All I want to do is audit drop commands. How do I do it?

Thanks in advance Received on Sun Sep 11 2005 - 19:40:36 CDT