Synonym Ignored
I have defined 2 user : usr1 and usr2 and I have 2 table table1 and table2.
I define one synonym for table1 that for the usr2 is link to table2.
If I run sqlplus80 connect whit usr1 and I execute 'Select * from table1'
the query run correctly on table1.
If I run sqlplus80 connect whit usr2 and I execute 'Select * from table1'
the query run correctly on table2.
After I wrote a stored procedure with the same query.
If I execute the strored procedure from sqlplus80 connect with usr1 It work correclty with table1.
If I execute the stored procedure from sqlplus80 connect with usr2 It don't work because contine to work with table1, it seem that don't use the synonym.
Can someone help me ?