Audit not captured in dba_audit_trail table
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;