| 标题 | oracle细粒度审计使用 |
| 范文 | 以scott用户的emp表为示例 ----增加策略 begin DBMS_FGA.ADD_POLICY ( object_schema => 'SCOTT', object_name => 'EMP', policy_name => 'mypolicy1', handler_schema => NULL, handler_module => NULL, enable => TRUE, statement_types => 'INSERT, UPDATE,DELETE', audit_column_opts => DBMS_FGA.ANY_COLUMNS); end; ----启用策略 begin DBMS_FGA.ENABLE_POLICY ( object_schema => 'SCOTT', object_name => 'EMP', policy_name => 'mypolicy1', enable => TRUE); end; select * from dba_fga_audit_trail; select * from dba_audit_policies; select db_user,timestamp,sql_text,sql_bind from dba_fga_audit_trail; --审计结果 SELECT text FROM dba_Views where view_name=upper('DBA_FGA_AUDIT_TRAIL'); --查看记录 ----删除策略 begin dbms_fga.drop_policy ( object_schema=>'SCOTT', object_name=>'EMP', policy_name=>'mypolicy1' ); end; |
| 随便看 |
|
在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板，是学习及工作的有利工具。