Re: audit 'revoke' statement

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 18 May 2004 22:34:24 -0700
Message-ID: <1084944868.133971@yasure>

Joe wrote:

> 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.
>

Alternatively look at creating a DDL trigger: http://www.psoug.org/reference/ddl_trigger.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed May 19 2004 - 00:34:24 CDT