Re: Why procedure cannot see table?

From: Stephen R. Egesdahl <stephen.egesdahl_at_nike.com>
Date: 1997/01/03
Message-ID: <32CD5F73.7BAB@nike.com>#1/1

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