Database Security Products (MOSC)

MOSC Banner

A drop table produces an entry for the drop and an alter command when auditing is turned on

edited Oct 7, 2009 11:44PM in Database Security Products (MOSC) 4 commentsAnswered
 When auditing is turned on and I do a

select * from ddl_log

* from ddl_log

it returns no rows

I then create a table by

create table test2 as select * from v$instance table test2 as select * from v$instance and then query from ddl_log and it returns 1 row for event CREATE. I then drop table test2 and then query from ddl_log and it returns 3 rows for event CREATE above, event DROP (expected), and event ALTER.

drop table test2

and then query from ddl_log and it returns 3 rows for event CREATE above, event DROP (expected), and event ALTER.

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