begin dbms_fga.add_policy ( object_schema=>'EDMS', object_name=>'T_AUDIT_DEMO', policy_name=>'T_AUDIT_DEMO_AUDIT' ); end;
3. 测试审计效果(用户EDMS下)
INSERTINTO T_AUDIT_DEMO VALUES(1,'曾勋','ZENG XUN'); INSERT INTO T_AUDIT_DEMO VALUES(2,'翁黎明','WENG LI MING'); INSERT INTO T_AUDIT_DEMO VALUES(3,'刘帝勇','LIU DI YONG');
4. 使用Select查询测试表(用户EDMS下)
SQL> SELECT * FROM T_AUDIT_DEMO; CID CNAME ENAME ----- -------------------- ------- 1 曾勋
ZENG XUN
2 翁黎明
WENG LI MING
3 刘帝勇
LIU DI YONG
5. 再次查看审计效果(用户SYS下)
SQL> select statement_type,SQL_TEXT from dba_fga_audit_trail; STATEMENT_TYPE SQL_TEXT -------------- ----------- SELECT SELECT * FROM T_AUDIT_DEMO