Dear experts,
we are having a very important table on 11g database so we would like to record that table droping information.
I tried by issueing below commands but no luck. Could you please help me how shall I enable audit for dropping table if I can enable by using only Trigger please provide the trigger code.. Thanks for yoru help.
audit drop table owner.table by session; --not working
audit create table by username; --executing the statement bur there is no result --checking in dba_audit_trail
audit drop any table; --executing the statement bur there is no result --checking in dba_audit_trail
Out Audit parameter details..
SQL> show parameter audit;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /path
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB
SQL>