Creating Synonyms

To create a synonym:

1. On the Workspace home page, click SQL Workshop and then Object Browser.

   Object Browser appears.

2. Click Create.

3. From the list of object types, select Synonym.

4. Define the synonym:

   1. Synonym Name - Enter a name.

   2. Public or Private - Specify whether the synonym should be public or private.

   3. Schema - Select the database schema (or user name) which owns the object upon which you want to create your synonym.

   4. Object - Enter the name of the object upon which you want to create a synonym.

   5. Database Link - Enter the name of the database link to use if the synonym is to be create on a remote object.

   6. Click Next.

   A confirmation page appears. To view the SQL used to create the synonym, click Show SQL.

5. Click Finish.