Re: calling plsql with invoker rights from trigger

misiacz1_at_free.polbox.pl (Michal Faber) wrote

> Oracle documentation says that it is impossible to call plsql
> procedure with invoker rights from trigger or views (i'm intrested in
> after logon trigger). They are invoked with owner rights. Is there any
> solution to call them with invoker rights some other ways?

DBMS_JOB. A trigger is there for providing data validation and integrity. Period. Anything else must be separated from the trigger itself - e.g. the most dorkish dead dumb brain thing I have seen with triggers, is people wanting to have it send e-mails and the like. That flies in the face of fundemental RDBMS design principles and make me reach for my lead pipe.

That type of thing has no place in a RDBMS table trigger. If a transaction should cause an e-mail event for example, then have the trigger generating that event OUTSIDE the current execution scope of the trigger - which in Oracle talk means using something like DBMS_JOB, DBMS_ALERT, or DBMS_AQ.

--
Billy