ADD_POLICY
-- SYS执行
EXEC DBMS_FGA.ADD_POLICY (
OBJECT_SCHEMA => 'SCOTT',
OBJECT_NAME => 'EMP',
POLICY_NAME => 'EMP_FGA',
AUDIT_COLUMN => 'COMM,SAL',
ENABLE => TRUE,
STATEMENT_TYPES => 'SELECT');
解释: 对SCOTT用户的EMP表的COMM字段和SAL字段的查询做审计。
验证
-- SCOTT执行
SELECT * FROM EMP;
SELECT SAL FROM EMP;
SELECT COMM FROM EMP;
--上面三句会被记录
SELECT EMPNO,ENAME FROM EMP;
-- SYS执行
SELECT SQL_TEXT FROM DBA_FGA_AUDIT_TRAIL;