Re: I hate auditing!!!

Use:

audit create table;
audit drop table;







extents@xxxxxxxxx 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

.

Relevant Pages

  • Re: [OT] Solaris crashes itself when /tmp is full
    ... > in article 402CEBAB.2AD40B83@sture.homeip.net, Paul Sture at ... When audit is in default or C2 mode the correct response is to ... > crash the system if an audit can't be logged. ... I am looking at the V7.3-2 documentation at ...
    (comp.os.vms)
  • Re: auditreduce(1M) and Large Files
    ... read audit data from stdin. ... looking at audit.logand some other documentation, ... I whipped up a quick Perl script that could ... deliver it to the intended recipient, you are hereby notified that any review, ...
    (SunManagers)
  • Re: I hate auditing!!!
    ... I think I have far too much documentation to this simple audit and still isnt working....Im doing a simple test. ... Shuldnt there be an entry in aud$ for dropping the table t3? ...
    (comp.databases.oracle.server)
  • I hate auditing!!!
    ... I think I have far too much documentation to this simple audit and ... Ran as sysdba ... audit create any table by access; ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Getting user input without using a form
    ... these old commands still work, but they have been removed from the ... documentation and their use is not recommended. ... Peter Rooney ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)