Synonyms as the word literally means, are aliases for referencing the database objects. By default, when you look for an object in the database, it tries to search it in your own schema. So, if you are user user01 and you try to query an object emp from scott's schema, oracle will return an error : sql> select * from emp select * from emp * ERROR at line 1: ORA-00942: table or view does not exist Why do we need synonyms? 1. Synonyms make the referencing of objects … [Read more...] about Beginners guide to oracle synonyms