Dear Friends


You have to run the following command if you have not created synonym.

SQL> select * from scott.emp;


You have to mentioned the owner name while running the query even you have granted the permission.

Or You can create synonym with EMP name and then you can run the following command.

SQL> select * from EMP;


CHEERS.....

Naresh Kakrani
Oracle DBA
Reliance Telecom Ltd