oracle fga審計(欄位級)

wanglinghua0907發表於2023-12-29

檢視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$


來自 “ ITPUB部落格 ” ,連結:https://blog.itpub.net/69980685/viewspace-3002131/,如需轉載,請註明出處,否則將追究法律責任。

相關文章