Dear Kanchan Maheshwari
There are two categories of synonyms, public and private.
A public synonym can be accessed by any system user.
The individual creating a public synonym does not own the synonym – rather, it will belong to the PUBLIC user group that exists within Oracle.
Private synonyms, on the other hand, belong to the system user that creates them and reside in that user's schema.
A system user can grant the privilege to use private synonyms that they own to other system users. In order to create synonyms, you will need to have the CREATE SYNONYM privilege.
This privilege will be granted to you by the DBA.
You must have the CREATE PUBLIC SYNONYM privilege in order to create public synonyms
Login to rate this answer.