What is Synonyms?

What is Synonyms?

What is Synonyms?

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:
what is bit
what is hibernate.archive.autodetection
Advertisements
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection
What is procedure
what is hibernate.archive.autodetection
What is Hibernate
What is Hibernate
What is JDBC?
What is FBT
What is ActionServlet?
What is Trigger?
What is VLR ?
What's PHP ?
What is an interface?
What is DML?
What is Index?
What is SQLLoader?
What is a "constraint"?
what is Savepoint ?
What is this keyword?
what is collections?
what are indices?
What is Hibernate
What is Hibernate
What is Externalizable?
What is the % operator?
What is casting?
What is IOC ?
What is SQLExceptionTranslator?
What is DataAccessException?
What are Struts?
What is WAP?
What is SPOOL?
What is CRM?
What is webservices?
What is Ajax?
What is NSRangeException
What is portal
what is posting?
What is a tuple?
What is workflow
what is RUP?
What was ENIAC
What is an Iterator?
What is WSP?
What is CDPD ?
What is RMS ?

Ads