Hi all
Please solve this issue. Thanks in advance
I have a table called prod_det in my schema. There is a Public synonym with same name prod_det in my Database but created for a different table X which is in some one's schema.
Now I have no Privilege to select data from X. Only way is I have is to use the synonym name prod_det.
Since I have a table in my schema with the same name It is retrieving data from my schema table only. How I can retrieve data from X using the synonym name prod_det.
Once again Thank you