How to make synonym useful for all users
Posted on 2004-08-07
I have a database instance. It has say two users. User1 and User2.
Say User1 has a table Table1. I want it to be made available by User2 in terms of a synonym.
So I create a public synonym using dba priviliges.
create public synonym nt_Table1 for user1.Table1;
Now when I go into User2 and do a select e.g
Select * from nt_Table1; I am unable to access that data.
But for sys login the same query returns me the data.
Please tell me as to why is this happening? What should I do so that the synonym returns me data even in User2 login.