Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Audit
Hi folks,
I would like to audit who has dropped a table.
I've set audit_trail=os in the init.ora and invoke
from SQL > audit drop any table by user1;
But, if user1 dropped a table, there is no information
in the audit_trail_dir telling me that user1 has dropped
a table.
Anything else that I need to set ?
Oracle 816, Linux2.6.
Tia,
Aldi
oracle DBA
![]() |
![]() |