Re: stored function question

From: <morris_newsgroup_at_yahoo.com>
Date: 1998/08/13
Message-ID: <6quttg$qoh$1_at_nnrp1.dejanews.com>#1/1

[Quoted] 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.

[Quoted] Why can't oracle use the roles granted to this owner when compiling?

Thanks,
Morris

---

[Quoted] 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 CEST