Audit???

• • Reply

  16 years ago

  by nguyennh

  Nguyen Hoang Nguyen

  Hanoi, Vietnam, Viet Nam

  Joined 16 years ago

  Hi all,
  I want to keep track every changing in my db such as create or drop table. So how do I know who create or drop any table if I did not active the Auditing in my DB.
  Thanks in advance.

  Report abuse
• • Reply

  15 years ago

  by Sekar Sai

  Sekar Sai

  , United States

  Joined 15 years ago

  Hi
  The simple way is use the supplied feature Oracle AUDIT.
  If you want to develop your own audit then
  1. Create a Database level trigger for DROP and CREATE
  2. Insert the seesion info in your audit table.
  

  Report abuse
• • Reply

  15 years ago

  by razoo

  e rajesh kumar

  , India

  Joined 15 years ago
  CAN U PLZ EXPLAIN HOW TO DO THAT.
  Report abuse