Re: Other user table reference in database package

From: dudester <duderino_at_zdnetmail.com>
Date: Fri, 09 Aug 2002 01:21:17 -0400
Message-ID: <3D53514D.4060307@zdnetmail.com>

Faisal Qasim wrote:
> Dear all,
>
> We are trying to access another user's tables in a database package.
> Those tables are successfully accessible from SQL directly as well as
> through synonym and proper permission is there. Oracle 7.3.4 is being
> used.
>
> Why does another user tables cannot be accessed in db. package? Are we
> missing something.
>
> I would be grateful for any hints.

Well, since Sy won't answer this question I guess it's up to me to save the day !!!

Permissions granted to individual users via roles are not propogated in packages. You need to grant the privileges to the package as well.

>
>
> Regards
>
> Faisal Qasim
Received on Fri Aug 09 2002 - 00:21:17 CDT