This discussion is archived
8 Replies Latest reply: Apr 25, 2013 3:10 PM by wlourens RSS

Need to Audit ALTER, DROP or TRUNCATE on All Tables in a Schema

Sky13 Newbie
Currently Being Moderated
Hello,
I need to audit any ALTER, DROP or TRUNCATE on all tables in the "X" schema including operations done by the "X" account.

Oracle Version = 11g Release 11.1.0.6.0
audit_sys_operations = TRUE
audit_trail = XML, EXTENDED

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points