Re: Why procedure cannot see table?

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1997/01/09
Message-ID: <5b3id0$q9u@nntp1.u.washington.edu>#1/1

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
Received on Thu Jan 09 1997 - 00:00:00 CST