Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: session_roles does not work inside of procedure
mark.powell_at_eds.com wrote in message <7ctq40$k1$1_at_nnrp1.dejanews.com>...
>In article <7crt5p$cep$1_at_nnrp1.dejanews.com>,
> v6turbo_at_my-dejanews.com wrote:
>> Question :
>>
>> How come I can not get any tuples to appear from the
>> session_roles view inside a procedure? I get all that
>> I need outside a procedure on the command line, just not
>> through the procedure.
>>
>> Keith
>> Keith_Monton_at_wstnres.com
>>
>> -----------== Posted via Deja News, The Discussion Network ==----------
>> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>>
>
>Roles are disabled in stored and packaged procedures as these execute as
the
>owner of the code. The owner of the code needs direct grants to select,
>insert, update, delete, or execute any referenced objects so a third party
>user needs only execute on the referenced code to accomplish whatever it is
>that the stored code does. Unnamed pl/sql blocks execute with the user's
>priviledges.
>
>Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
In 8i it's possible to use both definer's rights (as now) and invoker's rights (new).
Finn Received on Tue Mar 30 1999 - 19:38:42 CST