Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: audit 'revoke' statement

Re: audit 'revoke' statement

From: Alan <desertflowerln_at_yahoo.com>
Date: 19 May 2004 16:31:23 -0700
Message-ID: <b1217045.0405191531.5df3eb15@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 Received on Wed May 19 2004 - 18:31:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US