Oracle数据库审计

连接：conn /as sysdba;

打开审计：
alter system set audit_sys_operations=TRUE scope=spfile;
alter system set audit_trail=db scope=spfile;
startup force;

打开精细审计
audit all on dept;
exec dbms_fga.add_policy(object_name=>'dept',policy_name=>'chk_dept',statement_types=>'insert,update,delete,select');

查询审计
select db_user,sql_text from dba_fga_audit_trail;

取消精细审计
exec dbms_fga.disable_policy(object_name=>'dept',policy_name=>'chk_dept');

关闭表的审计
noaudit all on dept;