Creating and Managing Synonyms

A synonym is an alias for another schema object. Some reasons to use synonyms are security (for example, to hide the owner and location of an object) and convenience. Examples of convenience are:

• Using a short synonym, such as SALES, for a long object name, such as ACME_CO.SALES_DATA

• Using a synonym for a renamed object, instead of changing that object name throughout the applications that use it

  For example, if your application uses a table named DEPARTMENTS, and its name changes to DIVISIONS, you can create a DEPARTMENTS synonym for that table and continue to reference it by its original name.

This section contains:

• Creating Synonyms

• Dropping Synonyms