Create unified audit policy - Oracle Database Script. -- Create audit policy with audit options: 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'; -- Enable policy: audit policy TEST_CASE2; select distinct policy_name from AUDIT_UNIFIED_ENABLED_POLICIES where policy_name='TEST_CASE2';
-- Create audit policy with audit options: 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'; -- Enable policy: audit policy TEST_CASE2; select distinct policy_name from AUDIT_UNIFIED_ENABLED_POLICIES where policy_name='TEST_CASE2';