标题 | 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; |
随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。