Re: What privilege needs to be granted?

Ping wrote:

> Hello,
>
> Have a wonderful new year!
>
> I have oracle 9.2 on XP.
>
> There is a table T1 created by user U1 in U1's schema,
> a synonym S1 created also by U1 to point to T1 in U1's schema,
> U1 granted S1 to public for select.
>
>
> Procedure P2 created by user U2 in U2's schema,
> in P2, the S1 is referenced for select in a cursor.
>
>
> Problem and question:
> when P2 is compiled, got an error message saying that not sufficient
> privilege. I tried a set of privileges which worked on oracle 8.1.6,
> but not
> on oracle 9.2 I memtioned above.
>
>
> What is the privilege needed to be granted or something else needs to
> be done other than just granting privileges?
>
> Thanks in advance.
>
> Ping

Sigh... Roles are *not* active during PL/SQL execution, as mentioned many times in this ng.
For you to search the archives (or the documentation) for the solution

-- 
A prosperous 2004,
Regards,
Frank van Bortel