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 -> Re: alter session set sql_trace inside a procedure

Re: alter session set sql_trace inside a procedure

From: VC <boston103_at_hotmail.com>
Date: Fri, 05 Mar 2004 23:14:18 GMT
Message-ID: <eR72c.184716$jk2.668490@attbi_s53>


Pls. see below:

"FC" <flavio_at_tin.it> wrote in message
news:pW42c.3330$z23.119630_at_news3.tin.it...
>
> "VC" <boston103_at_hotmail.com> wrote in message
> news:Gv42c.183522$jk2.667605_at_attbi_s53...
> You're right, now it works, but why is that?

During a procedure execution with the default definer rights, all the roles are disabled.(for more information pls. see the PL/SQL manual or http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html ).

If roles were enabled for the definer right procedures, it would mean that the number of cases when a procedure is invalidated would be greatly increased. Virtually any time any role is modified, many procedures would need to be recompiled. Clearly, a situation like this is undesirable.
>
> Thanks,
> Flavio
>
>
Received on Fri Mar 05 2004 - 17:14:18 CST

Original text of this message

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