当前位置:Gxlcms > mysql > oracle细粒度审计使用

oracle细粒度审计使用

时间:2021-07-01 10:21:17 帮助过:13人阅读

以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,DELET

  以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;

人气教程排行