3.14 Managing Synonyms
A synonym is an alias for a schema object. Use Object Browser to create, view and drop a synonym.
Synonyms can provide a level of security by masking the name and owner of an object and providing location transparency for remote objects of a distributed database. Synonyms are also convenient to use and reduce the complexity of SQL statements for database users.
- Creating Synonyms
Use Object Browser to create synonyms. - Viewing a Synonym
View existing synonyms in Object Browser. - Dropping a Synonym
Select a synonym from the Object Selection pane and click Drop on the Object Details tab.
See Also:
Managing Views_ Sequences_ and Synonyms in Oracle Database Administrator’s Guide for information about synonyms
Parent topic: Managing Database Objects with Object Browser
3.14.1 Creating Synonyms
Use Object Browser to create synonyms.
To create a synonym:
On Create Synonym:
Parent topic: Managing Synonyms
3.14.2 Viewing a Synonym
View existing synonyms in Object Browser.
To view an existing synonym:
Parent topic: Managing Synonyms
3.14.3 Dropping a Synonym
Select a synonym from the Object Selection pane and click Drop on the Object Details tab.
To drop a synonym:
Parent topic: Managing Synonyms