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?
Thanks,
Morris
In article <6qtams$jjm$1_at_home.kpbank.ru>,
"skv" <skv_at_kpbank.ru> wrote:
> hi Moris
> morris_newsgroup_at_yahoo.com ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <6qt7je$uug$1_at_nnrp1.dejanews.com>
> ...
> >I can do a select on a SYNONYM of a table
> >at the sqlplus prompt successfully. However,
> >when I referred to this SYNONYM in a stored
> >function, Oracle had trouble in compiling the
> >stored function. Suppose the name of the SYNONYM
> >is called 'USERPRODUCT', I got the following error
> >when compiling:
> >
> >SQL> show errors;
> >Errors for FUNCTION SF_GET_SEARCH_CNT:
> >
> >LINE/COL ERROR
> >-------- -----------------------------------------------------------------
> >6/1 PL/SQL: SQL Statement ignored
> >6/31 PLS-00201: identifier 'USERPRODUCT' must be declared
> >
> >Does anyone know why?
> GRANT SELECT ON USERPRODUCT TO your_function_owner
> solves yor problem
>
> Regards
>
> ---------------------------------
> Konstantin V. Sartakov
> Kuzbassprombank
> Kemerovo
> Russia
> mailto:skv_at_kpbank.ru
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Aug 13 1998 - 00:00:00 CDT