Stored procedures and Roles
From: Judy Munn <munn_at_hq.mag.aramark.com>
Date: 1997/01/28
Message-ID: <E4qr9v.BuI_at_news.mag.aramark.com>#1/1
Date: 1997/01/28
Message-ID: <E4qr9v.BuI_at_news.mag.aramark.com>#1/1
We are having the following problem:
A role (Developer) is created with insert, update, delete, and select object privileges to certain tables.
User JOE with Role Developer can access these tables through a sql select statement BUT CANNOT access these tables through a stored procedure defined within a package. He gets the following error:
PLS-00201: identifier 'JANE.CONTRACT_TABLE' must be declared PL/SQL: Declaration ignored
However, if I create the same object privileges directly to user JOE, everything works okay.
We are using ORACLE 7.3. Is this a bug? Does anyone know a workaround?
Thanks!
Judy Munn Received on Tue Jan 28 1997 - 00:00:00 CET