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: Questions on Oracle Database Auditing

Re: Questions on Oracle Database Auditing

From: Anurag Varma <anuragvidya_at_gmail.com>
Date: 27 Jan 2005 14:41:11 -0800
Message-ID: <1106865671.150985.113780@c13g2000cwb.googlegroups.com>

Well .. I need to correct my statement about auditing on create table..:)
"create table" is in the list of system privs. "drop table" or
"truncate" isn't.

select * from system_privilege_map;

will show you the list of privs which can be audited. Thus create table can be audited while drop table can't.

In your case, if you could perhaps use schema / database triggers to do a more selective audit. Received on Thu Jan 27 2005 - 16:41:11 CST

Original text of this message

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