Oracle查詢歷史操作記錄

 1.以sysdba身份進入

 

 2.show parameter audit

 

 3.alter system set audit_sys_operations = true scope = spfile

 

 4.alter system set audit_trail = db,extended scope = spfile

 

 5.startup force

 

 6.show parameter audit

 

 7.audit select table,insert table,delete table,execute procedure by access

 

===========================================================

 

查詢目前已打開審計功能的項目,使用SQL語句如下:select * from  dba_stmt_audit_opts(查詢出來的欄位有USER_NAME,PROXY_NAME,AUDIT_OPTION,SUCCESS,FAILURE)

 

若需要關閉其中部分的審計.則需要noaudit  AUDIT_OPTION某個欄位的值即可