PL/SQL (MOSC)

MOSC Banner

Restricting the trigger to fire only selectively

edited Feb 25, 2020 4:04PM in PL/SQL (MOSC) 8 commentsAnswered ✓

Hello everyone

We are looking for advise on one issue that we are currently facing on our 11.2.0.4 Database

We have an "AFTER INSERT" trigger on a table ABC that INSERTS records in a table XYZ when fired

Would it be possible for this trigger to FIRE only IF the user or the machine or process matches a given criteria?

Like for example, if the owner of the process or module that is inserting data in the table ABC is USER_ABC or module is MSACESS.EXE , only then FIRE the trigger

OR

Similarly, if the owner of the process or session that INSERTS the records in table ABC is USER_XYZ then do not fire the trigger. If it is any other user, then fire it

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