What privilege needs to be granted?
From: Ping <pl3_at_njit.edu>
Date: 1 Jan 2004 11:03:02 -0800
Message-ID: <2daccd98.0401011103.71818264_at_posting.google.com>
Date: 1 Jan 2004 11:03:02 -0800
Message-ID: <2daccd98.0401011103.71818264_at_posting.google.com>
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:
What is the privilege needed to be granted or something else needs to
be done other than just granting privileges?
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.
Thanks in advance.
Ping Received on Thu Jan 01 2004 - 20:03:02 CET