Re: PL/SQL error ..Cannot find Table..

In article dated Wed, 02 Oct 1996 09:37:16 -0400, janet (janet_at_telesph.com) wrote:
> Srinivasa Rao Vaikuntam wrote:
> >
> > We are working on a project, where several developers are coding
> > procedures. However, the developers log with their own username and
> > access the schema's objects.
> >
> > through SQL*Plus, PL/SQL gives a compilation error, saying that the
> > table/object could not be found.
>
> srini,
> have you tried a synonym? just alias tablename as owner.tablename
> for all the developers usernames.

The problem is not that. Under 7.1.6.2 I've found that from within a stored procedure, function or package you can't make use of any table privileges you get through a role. Your only option is to grant the table privileges direct to the owner of the package. Grr!

Even Data Browser can't save a query to the database where privileges on the tables used is the query are gained through the role.

--
 _--_|\  John Verhoeven           Unix / Database Administrator Westrail
/      \              johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
      v   "Smile! things could be worse... So I did... and they were..."