Online Documentation for SQL Manager for Oracle

Creating/editing synonym


Use the Synonym tab of Synonym Editor to create/edit a synonym and specify its properties.

 

Name

Specify the name of the synonym to be created, or view the name of the synonym being edited. Note that the synonym name must be unique within its schema.

 

Schema

Use the drop-down list to specify the schema in which the synonym will be created.

 

Synonym Editor - Editing synonym definition

 

CheckBox Public synonym

Select this option to create a public synonym. Public synonyms are accessible to all users. However, each user must have appropriate privileges on the underlying object in order to use the synonym.

 

DB Link name

You can use this drop-down list to specify a complete or partial database link to create a synonym for a schema object on a remote database where the object is located.

 

Object schema

Use the drop-down list to select the schema where the base object resides.

 

Object name

Type in the name of the base object to be referenced by the synonym, or click the Select object button to specify an object using the Select object dialog.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.