oracle fga审计（字段级）

查看fga审计规则 select * from dba_audit_policies; 查看fga审计记录 select * from dba_fga_audit_trail; 对应基表sys.fga_log$   该表带lob字段， 暂停fga审计 exec dbms_fga.disable_policy(object_schema=>'BSUSER', object_name=> 'MS_BRDA', policy_name=> 'MS_BRDA_AUDIT'); 删除fga审计 exec dbms_fga.drop_policy(object_schema=>'BSUSER', object_name=> 'MS_BRDA', policy_name=> 'MS_BRDA_AUDIT'); 清理日志表 truncate table sys.fga_log$