日期:2014-05-16 浏览次数:20535 次
SQL〉show parameter audit_trail;如果参数值为true,则到第4步,否则继续第2步。
SQL> alter system set audit_trail=true scope=spfile;
SQL> shutdown immediate; SQL> startup
SQL> AUDIT INSERT,SELECT,DELETE,UPDATE on TableName by ACCESS WHENEVER SUCCESSFUL;
SQL> SELECT OBJ_NAME,ACTION_NAME ,to_char(timestamp,'dd/mm/yyyy , HH:MM:SS') from sys.dba_audit_object;