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

From: janet <janet_at_telesph.com>
Date: 1996/10/04
Message-ID: <32555FD8.2BCE_at_telesph.com>#1/1


> > Srinivasa Rao Vaikuntam wrote:
> > > through SQL*Plus, PL/SQL gives a compilation error, saying that the
> > > table/object could not be found.
> >

 janet wrote:
> > srini,
> > have you tried a synonym? just alias tablename as owner.tablename
> > for all the developers usernames.
> John Verhoeven wrote:
> 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.
>

Oh well. that'll teach ME for trying to go for the simple solution! I was hoping it didn't involve roles & privileges (not my forte). I stand (actually sit) here humbled.
:-)
janet Received on Fri Oct 04 1996 - 00:00:00 CEST

Original text of this message