Re: I hate auditing!!!

Use:

 audit create table;
 audit drop table;

extents_at_gmail.com wrote:
> 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 Mon Sep 12 2005 - 01:58:06 CDT