Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: stored function question
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
![]() |
![]() |