DBA Hub

📋Steps in this guide1/1

Create unified audit policy

-- Create audit policy with audit options:

oracle configurationintermediate
by OracleDba
11 views
1

Create unified audit policy

-- Create audit policy with audit options: -- Enable policy:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
create audit policy test_case2
ACTIONS CREATE TABLE,
INSERT ON bsstdba.EMP_TAB,
TRUNCATE TABLE,
select on bsstdba.PROD_TAB;
select POLICY_NAME,audit_option,AUDIT_CONDITION,OBJECT_SCHEMA,OBJECT_NAME FROM
AUDIT_UNIFIED_POLICIES where POLICY_NAME='TEST_CASE2';
audit policy TEST_CASE2;
select distinct policy_name from AUDIT_UNIFIED_ENABLED_POLICIES where policy_name='TEST_CASE2';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!