Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> calling plsql with invoker rights from trigger

calling plsql with invoker rights from trigger

From: Michal Faber <misiacz1_at_free.polbox.pl>
Date: 19 Feb 2004 02:21:54 -0800
Message-ID: <3d3f0edf.0402190221.69794154@posting.google.com>


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? Received on Thu Feb 19 2004 - 04:21:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US