Re: What privilege needs to be granted?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 02 Jan 2004 10:09:39 +0100
Message-ID: <bt3bur$38u$1_at_news4.tilbu1.nb.home.nl>


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
Received on Fri Jan 02 2004 - 10:09:39 CET

Original text of this message