Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  

What is Synonyms?



Share on Google+Share on Google+

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

What is Synonyms?

View Answers

November 19, 2010 at 4:47 PM


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.