oracle细粒度审计脚本批量生成

最新推荐文章于 2021-04-06 22:03:27 发布

xwb926

最新推荐文章于 2021-04-06 22:03:27 发布

阅读量514

点赞数

分类专栏： oracle数据库管理文章标签： oracle 11g 细粒度审计审计

本文链接：https://blog.csdn.net/xwb926/article/details/38898617

版权

oracle数据库管理专栏收录该内容

6 篇文章 0 订阅

订阅专栏

--------创建细粒度策略
select 'begin' || chr(10) || 'dbms_fga.add_policy(object_schema =>''' ||
owner || ''',' || chr(10) ||
' object_name =>''' || table_name || '''' || ',' ||
chr(10) ||
' policy_name => ''ACCOUNT_ACCESS'',' ||
chr(10) ||
' statement_types => ''INSERT,UPDATE,DELETE,SELECT'');' ||
chr(10) || 'end;' || chr(10) || '/'
from dba_tables
where owner = 'BLUE';

------------删除细粒度策略
select 'begin' || chr(10) || 'dbms_fga.drop_policy(object_schema =>''' ||
owner || ''',' || chr(10) ||
' object_name =>''' || table_name || '''' || ',' ||
chr(10) ||
' policy_name => ''ACCOUNT_ACCESS'');' ||
chr(10) || 'end;' || chr(10) || '/'
from dba_tables
where owner = 'BLUE';

select * from DBA_AUDIT_POLICIES;

select * from dba_common_audit_trail;