Re: Questions on Oracle Database Auditing

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