Database Administration (MOSC)

MOSC Banner

Audit not captured in dba_audit_trail table

edited Jan 19, 2023 12:11AM in Database Administration (MOSC) 6 commentsAnswered

Oracle Enterprise Edition: 19.15 / RAC / CDB/PDB environment.

Steps:

***** Created a POLICY

 CREATE AUDIT POLICY ORA_TABLE_AUDIT_TEST

 ACTIONS

 CREATE TABLE, DROP TABLE, TRUNCATE TABLE, ALTER TABLE;

 

***** Assigned Policy to user

AUDIT POLICY ORA_TABLE_AUDIT_TEST by PPRX_AUDIT_TEST;

****** Audit setup ?

SELECT * FROM AUDIT_UNIFIED_ENABLED_POLICIES

  WHERE ENTITY_NAME like 'PPRX%'


***** Create table

create table PPRX_AUDIT_TEST.department

(DNUM NUMBER(2),

DNAME VARCHAR2(12),

DLOCATION VARCHAR2(6))


***** ALTER - Drop Column

alter table  PPRX_AUDIT_TEST.department drop  (DLOCATION);

-- ALTER - Rename Column

ALTER TABLE PPRX_AUDIT_TEST.department RENAME COLUMN DNUM to DEPT_NUM;

ALTER TABLE PPRX_AUDIT_TEST.department RENAME COLUMN DNAME to DEPT_NAME;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center