Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is Synonyms?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is Synonyms?
1 Answer(s)      4 years and 2 months ago
Posted in : SQL


What is Synonyms?


Advertisement
View Answers

November 19, 2010 at 4:47 PM


Hi,

A synonym is an alias for a database object (table, view, procedure, function, package, sequence, etc.) and are created for reasons of Security and Convenience. Synonyms may be used to reference the original object in SQL as wel as PL/SQL.

They can be used to hide ownership and location of the database objects they refer to and minimize the impact of moving or renaming the database objects.

There are two types of synonyms:

private- Private synonyms exist only in a specific user schema. The owner of the synonym maintains control over availability to other users.

public- A public synonym is available to all users.

Thanks.



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com