Series: Subject: Topic:
Question: 71 of 492

PL/SQL Synonym

What are the advantage of Synonym in PL/SQL
Asked by: kanchanG | Member Since Jan-2009 | Asked on: Jul 7th, 2010

View all questions by kanchanG   View all answers by kanchanG

Showing Answers 1 - 1 of 1 Answers

Answered On : Jul 9th, 2010

View all answers by mukesh1009

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.

Give your answer:

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



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.