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.We've run into this problem here as well. Unfortunately, grants on
procs have to be at the user level, not the role level. As well, be careful which user-id you're using when creating procs, any data accessed is the default for the proc creator... In other words, user A has proc A which accesses table A in user A's schema. User be also has a table A in his schema, and calls proc A. A's table data is accessed, not B's! (at least, that is the way that it looks here)... Received on Wed Jul 10 1996 - 00:00:00 CEST