Re: Execute privileges on PL/SQL function based upon role

William D Carey wrote:
>
> The way the ORACLE manuals read, it seems legitimate to grant execute
> on a function to a role and then grant the role to a user.
> The user should then be able to execute the function.
> Instead I get a PLS-00201 identifier 'FUNCTION_NAME' must be declared.
> Granting execute on the function to the user directly worked as well
> as granting execute on the function to PUBLIC.

This is legitimate. Sounds like you aren't doing anything wrong. Set echo on and spool your output so we can review the syntax. Received on Sat Jul 13 1996 - 00:00:00 CEST