Oracle 审计audit 的技巧使用,追踪oracle后台数据库的DML动作
来源:互联网 发布:数独出题软件 编辑:程序博客网 时间:2024/06/05 16:50
create or replace package aa_pkg_monitor_business_sql is
procedure pro_monitor_drop_policy(object_schema in varchar2);
procedure pro_monitor_add_policy(object_schema in varchar2);
procedure pro_monitor_drop_main;
procedure pro_monitor_add_main;
end;
/
create or replace package body aa_pkg_monitor_business_sql is
/*
truncate table sys.fga_log$ ;
select t.* from dba_fga_audit_trail t;
*/
procedure pro_monitor_drop_policy(object_schema in varchar2) is
cursor cur_del is
select owner, table_name from dba_tables a where owner = object_schema;
begin
for v_cur in cur_del
loop
begin
dbms_fga.drop_policy(object_schema => v_cur.owner, ---
object_name => v_cur.table_name, ---
policy_name => v_cur.table_name);
exception
when others then
null;
end;
end loop;
end pro_monitor_drop_policy;
--------------------------------------------------------------------
--------------------------------------------------------------------
procedure pro_monitor_add_policy(object_schema in varchar2) is
cursor cur_del is
select owner, table_name
from dba_tables a
where owner = object_schema and
a.table_name not like 'SRP%';
begin
for v_cur in cur_del
loop
begin
dbms_fga.add_policy(object_schema => v_cur.owner, --
object_name => v_cur.table_name, --
policy_name => v_cur.table_name,
statement_types => 'SELECT,UPDATE,DELETE,INSERT',
enable => true);
exception
when others then
null;
end;
end loop;
end pro_monitor_add_policy;
--------------------------------------------------------------------
--------------------------------------------------------------------
procedure pro_monitor_drop_main is
begin
pro_monitor_drop_policy('CCARE');
pro_monitor_drop_policy('CRMPUB');
pro_monitor_drop_policy('INVENTORY');
pro_monitor_drop_policy('ISAP');
pro_monitor_drop_policy('OSMS');
pro_monitor_drop_policy('ECARE');
pro_monitor_drop_policy('CHANNEL');
end pro_monitor_drop_main;
--------------------------------------------------------------------
--------------------------------------------------------------------
--------------------------------------------------------------------
--------------------------------------------------------------------
procedure pro_monitor_add_main is
begin
pro_monitor_drop_main;
pro_monitor_add_policy('CCARE');
-- pro_monitor_add_policy('CRMPUB');
pro_monitor_add_policy('INVENTORY');
--pro_monitor_add_policy('ISAP');
---pro_monitor_add_policy('OSMS');
end pro_monitor_add_main;
end;
/
- Oracle 审计audit 的技巧使用,追踪oracle后台数据库的DML动作
- ORACLE的数据库审计 audit
- Oracle 审计失败的用户登陆(Oracle audit)
- Oracle Audit 审计 说明
- Oracle 审计功能 Audit
- oracle数据审计 AUDIT
- 关于Oracle审计(audit)
- Oracle Audit 审计 说明
- oracle开启audit(审计)
- Oracle Audit 审计
- Oracle 审计功能 Audit
- oracle开启audit(审计)
- Oracle 审计功能 Audit
- Oracle 审计功能 Audit
- Oracle FGA(Fine-Grained Audit)细粒度审计的用法
- ORACLE AUDIT 审计(转)
- oracle开启audit审计功能
- 数据库安全 Oracle审计Audit
- Android 中ContentProvider和Uri详解
- 微软MSDN中文(简体)全下载及文件说明
- 在.Net Compact Framework中为ListView添加Context Menu(Tap and hold)
- 把文件写到数据库
- matlab GUI的handles
- Oracle 审计audit 的技巧使用,追踪oracle后台数据库的DML动作
- varnish几个工具命令行工作情况
- 为什么一个按钮在左边,其余的按钮都在右边?
- tempdb数据库简介及优化
- 文本编辑器js+java
- android开发笔记
- fckeditor 中提示invalid file type 问题
- NSPredicate的用法
- javadoc 命令