Database Security Products (MOSC)

MOSC Banner

drop table not appearing in audit trail

edited Oct 7, 2009 11:19PM in Database Security Products (MOSC) 4 comments
I am in the process of setting up auditing but notice that during my testing the drop statement does not appear to be audited.

The create table statement is audited.

I have set auditing on by issuing the statement "audit table".

I then issued the following statements, but the drop table does not appear to have been audited. Looking at the documentation at http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_48a.htm#2059412 my understanding is that this will be audited.

Any help would be greatly appreciated.

Neil

create table t1(n number);

drop table t1;

The detail from dba_audit_trail is as follows...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center