Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why procedure cannot see table?
Patrick Tan wrote:
>
> It is a bug in Oracle 7.1. It should be fixed in Oracle 7.2+
>
> Patrick
This 'feature' ;-) still exists in v7.3.2.2, i.e. a stored procedure/function can only see tables that the owner of the stored procedure has been granted the rights explicitly, not inherited through a role.
-- ================================================================ Stephen R. Egesdahl email: stephen.egesdahl_at_nike.com Senior Oracle DBA/DA phone: (503)671-NIKE ================================================================ The opinions expressed are my own and do not necessarily reflect those of Nike, Inc. ================================================================Received on Fri Jan 03 1997 - 00:00:00 CST