Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> What privilege needs to be granted?

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@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:
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 Received on Thu Jan 01 2004 - 13:03:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US