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: Joe <nospam_at_joekaz.net>
Date: Tue, 18 May 2004 20:52:53 -0400
Message-ID: <xcyqc.9799$if5.8512@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.


-- 
Joe
http://www.joekaz.net/
http://www.cafeshops.com/joekaz


Received on Tue May 18 2004 - 19:52:53 CDT












Original text of this message













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