Re: stored function question

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Thu, 13 Aug 1998 19:23:49 GMT
Message-ID: <6qvege$ibl$1@trader.ipf.de>

On Thu, 13 Aug 1998 14:40:48 GMT, morris_newsgroup_at_yahoo.com wrote:

>Did you mean even if an owner granted with the privilege thru. a role, =
the
>same owner creating the stored function will not be able to use this
>privilege when compiling? Instead, this owner needs to be granted the
>privilege directly.
>
>Why can't oracle use the roles granted to this owner when compiling?

Hi Morris,

privileges granted through roles are not in effect during stored procedure (, function, package) execution.

HTH
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Thu Aug 13 1998 - 14:23:49 CDT