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

In article <31E72B97.2BE3_at_one.net>, drbrown_at_one.net says...
>
>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.

May also want to check synonyms to ensure it is visible.

Boring autocratic new server stuff follows Boring autocratic new server stuff follows Boring autocratic new server stuff follows Boring autocratic new server stuff follows Boring autocratic new server stuff follows Boring autocratic new server stuff follows Boring autocratic new server stuff follows Boring autocratic new server stuff follows Received on Sun Jul 14 1996 - 00:00:00 CEST