Oracle审计语句简单使用(1)(2)

SQL> noaudit all on dept; 
审计未成功。

SQL> show user; 
USER 为 "MZL"

SQL> exec dbms_fga.add_policy(object_name=>'dept',policy_name=>'chk_dept',- 
> statement_types=>'insert,update,delete,select'); 
PL/SQL 过程已成功完成。 
SQL> select count(*) from dba_fga_audit_trail; 
COUNT(*) 
---------- 
0 
SQL> select * from dept; 
DEPTNO DNAME LOC 
---------- -------------- ------------- 
10 ACCOUNTING NEW YORK 
20 RESEARCH DALLAS 
30 SALES CHICAGO 
40 OPERATIONS PanJin 
60 June ShangHai 
80 mengzhaoliang beijing 
90 test PanJin 
已选择7行。 
SQL> delete dept where deptno=90; 
已删除 1 行。 
SQL> commit; 
提交完成。 
SQL> conn scott/mzl 
已连接。 
SQL> update dept set loc='PanJin' where deptno=60; 
已更新 1 行。 
SQL> commit; 
提交完成。 
SQL> conn mzl/mzl 
已连接。 
SQL> select count(*) from dba_fga_audit_trail; 
COUNT(*) 
---------- 
3 
SQL> col sql_text for a40 
SQL> l 
1* select db_user,sql_text from dba_fga_audit_trail 
SQL> / 
DB_USER SQL_TEXT 
------------------------------ ---------------------------------------- 
MZL select * from dept 
MZL delete dept where deptno=90 
SCOTT update dept set loc='PanJin' where deptn 
o=60

SQL> exec dbms_fga.disable_policy(object_name=>'dept',- 
> policy_name=>'chk_dept'); 
PL/SQL 过程已成功完成。