Database Administration (MOSC)

MOSC Banner

Need to enable audit option for triggers

Hi Experts,

Application team written code to disable triggers in a table and perform insert and after that they will enable the triggers for that table. they aye doing this do minimize the data insert in the table that are being triggered when condition met.


They have reported something or someone is preventing the triggers from disabling it , and it was in enable state which triggered data insertion in corresponding tables. we need to identify who or what blocking the trigger to get disable.


we have enabled audit all option on that table and alter option also, but it didnt capture the action in dba_audit_trail. it captured only DML operation Please advice is there any way to enable audit for triggers alone, i have googled and go through many link but unable to find the exact way. please help me in this issue.

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