PL/SQL (MOSC)

MOSC Banner

How can I delay the trigger action.

edited Apr 22, 2016 5:00AM in PL/SQL (MOSC) 14 commentsAnswered

How can I delay the trigger action. e.g I want to write a trigger to grant table access to other users as soon as  the table is created. But the issue is grant cannot be given unless the create operation is finished. So want to delay the trigger action till the table is created. I don't want to use JOB thru triggers as it creates issues during database refresh. Also dont want to disable or enable the trigger.

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