Re: Why procedure cannot see table?

Hi,
  There is no reason why the procedures cannot be owned by one user then 'execute' privilege granted to a role. After that grant the role to each of your 300+ users. This avoids having to grant to each of the users and yet each user can run the procedures. The users will not be able to create their own procedures using the 'role granted' procedures, but that is not normally a problem in a production environment.

Graham

lesliet_at_u.washington.edu (L. Tseng), thoughtfully produced:

>I doubt this is a bug, Patrick.
>
>It is still enforced in Oracle 7.3.
>However, I could not think of any good reason as to why Oracle
>implemented this feature? It's quite annoying in a stored procedure
>intensive environment. For instance, I have 300+ procs and 300+ users
>I need to grant execute priviliege of each proc to each user.
>Can someone give a workaround on this, please?
>
>
>In article <32C919E0.4DB8_at_mindspring.com>,
>Patrick Tan <ptan_at_mindspring.com> wrote:
>>It is a bug in Oracle 7.1. It should be fixed in Oracle 7.2+
>>
>>Patrick
>
>

Graham Miller ...
Opinions expressed are mine, they are free, and worth exactly what they cost. Received on Sun Jan 12 1997 - 00:00:00 CST