Oracle Maestro online help
Public Synonyms
Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another 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.
When resolving references to an object, Oracle Database uses a public synonym only if the object is not prefaced by a schema and is not followed by a database link.
New public synonyms are created within Create Public Synonym Wizard. In order to run the wizard you should either
| • | select the Object | Create Database Object... main menu item; |
| • | select the Public Synonym icon in the Create Database Object dialog |
or
| • | select the Public Synonym list or any object from that list in the explorer tree; |
| • | select the Create New Public Synonym... item from the popup menu |
or
| • | open the schema in Schema Editor and the Public Synonyms tab there; |
| • | press the Insert key or select the Create New Public Synonym item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
To create a new public synonym with the same properties as one of the existing public synonym has:
| • | select the Object | Duplicate Database Object... main menu item; |
| • | follow the instructions of Duplicate Object Wizard. |
|
Public synonyms can be edited within Public Synonym Editor. In order to run the editor you should either
| • | select the public synonym for editing in the explorer tree (type the first letters of the public synonym name for quick search); |
| • | select the Edit Public Synonym... item from the popup menu |
or
| • | open the database in Database Editor and the Public Synonyms tab there; |
| • | select the public synonym to edit; |
| • | press the Enter key or select the Edit Public Synonym item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
You can change the name of the public synonym using the Rename Public Synonym dialog. To open the dialog you should either
| • | select the public synonym to rename in the explorer tree; |
| • | select the Rename Public Synonym item from the popup menu |
or
| • | open the database in Database Editor and the Public Synonyms tab there; |
| • | select the public synonym to rename; |
| • | select the Rename Public Synonym item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
|
To drop a public synonym:
| • | select the public synonym to drop in the explorer tree; |
| • | select the Drop Public Synonym item from the popup menu |
or
| • | open the schema in Schema Editor and the Public Synonyms tab there; |
| • | select the public synonym to drop; |
| • | press the Delete key or select the Drop Public Synonym item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar) |
and confirm dropping in the dialog window.
|
Partners
Download
Buy
