What is Synonyms?

Ads

 
 

Share on Google+Share on Google+

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

What is Synonyms?

Ads
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.


Ads