Re: audit 'revoke' statement

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 20 May 2004 08:01:09 +0200
Message-ID: <40ac4a34$0$26908$626a14ce@news.free.fr>

"Alan" <desertflowerln_at_yahoo.com> a écrit dans le message de news:b1217045.0405191531.5df3eb15_at_posting.google.com...
> Joe <nospam_at_joekaz.net> wrote in message news:<xcyqc.9799$if5.8512_at_fe17.usenetserver.com>...
> > On 05/18/2004 07:53 PM, Alan said:
> > > Does anyone know how can I audit any 'revoke' statements?
> >
> > Do: AUDIT SYSTEM GRANT;
> > This will audit all grants and revokes of roles and privileges.
> > Also make sure that the init.ora AUDIT_TRAIL=DB,
> > otherwise the audit statement will have no effect.
>
> Do you know which view will this audit result be kept?
>
> Thanks,
> Alan

dba_audit_statement and dba_audit_trail.

Regards
Michel Cadot Received on Thu May 20 2004 - 01:01:09 CDT