Database Administration (MOSC)

MOSC Banner

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?

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