PL/SQL Synonym

What are the advantage of Synonym in PL/SQL

Questions by kanchanG   answers by kanchanG

Showing Answers 1 - 1 of 1 Answers


  • Jul 9th, 2010

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions