Problem in synonym access through JAVA
743632Sep 10 2010 — edited Sep 13 2010Hi All,
We are facing one issue in access the oracle synonym through java.I am explain you the scenario below:
1. We have one table T1 in One Oracle User U1.
2. We have created the synonym(*Synonym name is S1*) for T1 table in another oracle user U2.
3. When we are executing SELECT * FROM S1 from SQL PLUS in user U2. Its giving the expected result.But when we are accessing this table through JAVA code,its giving the "SQLException :: ORA-01031: insufficient privileges" .
In java code we are connecting with Oracle USER2.
4. If we are changing the name of the synonym in USER2 from S1 TO S2 then it is working fine.
Can somebody help me to resolve the problem?
Note: 1. My Oracle Version is Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
2. This is right forum for this type of questions if no then someone tell me the name of the right forum.
Thanks in advance...
Edited by: user00001 on 09-Sep-2010 23:52
Edited by: user00001 on 09-Sep-2010 23:55