Execute privileges on PL/SQL function based upon role

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.

I tried this on Oracle v 7.1.4 on AIX 3 and the function is on a local database, not a remote one.

I would appreciate any feedback on my problem.

Will Carey Received on Tue Jul 09 1996 - 00:00:00 CEST