hemant kumar
What is Synonyms?
1 Answer(s)      4 years and 5 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.