After DDL on Schema
Oracle 19c - RAC database
I need to setup an audit for all DDL and may including truncate table.
I created the following trigger as a table owner and it works well, but i have few questions.
Q1. I have the following columns in the audit trigger and the table(DB_AUDITOR.AUDIT_PVRPT_DEV_TABLES_DDL), Columns: DDL_DATE, DDL_USER, OBJECT_CREATED, OBJECT_NAME, DDL_OPERATION, what other columns can I add?
Q2. How can I add column to capture which DDL statement ran? for example, If I ran, alter table pv_drug_price modify(drug_bin varchar2(15)), How can I capture this in ddl audit?