synonym for a synonym [message #19468] |
Wed, 20 March 2002 22:25 |
Synonymous
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
I have a synonym SYMA pointing to a table TABA.
I am trying to create another synonym SYMB pointing to SYMA, so as to query TABA in my program.
But I am getting the following error:
ORA-00942: table or view does not exist.
When I try to create a synonym for TABA directly, it works fine.
What am I doing wrong?
Thanks.
|
|
|
|
|
Re: synonym for a synonym [message #19511 is a reply to message #19468] |
Fri, 22 March 2002 07:37 |
oraboy
Messages: 97 Registered: October 2001
|
Member |
|
|
This is very much possible.
There is no restriction as to you have to create a synonym only for a table or view..
Check out whether you are creating the second syn'm SYMB from the same schema where u have SYMA..
Else check out whether you have SYMA as a public synonym!
Regards
Oraboy
|
|
|
Re: synonym for a synonym [message #19516 is a reply to message #19468] |
Fri, 22 March 2002 15:37 |
Sudhakar Atmakuru
Messages: 58 Registered: May 2001
|
Member |
|
|
Either you are trying to create the second synonym from another user or you dont have the privilege granted by the creator of TABA. Have the creator of TABA granted you the SELECT and UPDATE privileges on TABA WITH GRANT OPTION. The WITH GRANT OPTION enables the creator of first synonym to pass on his/her privileges to other users to create one or more synonyms on the one already created. Otherwise, the ORACLE does not let you access a table which you are not privileged to access. Get the following done by the creator of TABA.
GRANT SELECT, UPATE ON TABA TO yourname WITH GRANT OPTION;
This should work. Try it out.
Good luck :)
|
|
|