Re: Problem executing stored function

Kevin S. DeWitt wrote:
>
> I have a stored function created by user A that works fine for user A.
> However, user B cannot 'see' this function from his SELECT. User A
> granted EXECUTE privileges to a global role that all users belong to.
> User A also created a PUBLIC synonym for the stored function. An
> example follows:
>
> SELECT qty_of_trading_instr_executed(100) FROM DUAL;
>
> User A returns the correct value. User B gets:
>
> PLS-00201: identifier 'QTY_OF_TRADING_INSTR_EXECUTED' must be
> declared

  You need to grant SELECT on QTY_OF_TRADING_INSTR_EXECUTED explicitly to user B. You cannot grant it through roles.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841