Chapter 13 Managing Database Access
In PowerDesigner synonyms are created for base objects. The base object is the object used to create a synonym. Base objects support multiple synonyms while each synonym must have only one base object. You can view the synonyms depending on a base object in the Dependencies page of the base object property sheet.
If you delete the base object of a synonym, the synonym is deleted as well.
Synonyms have the following properties:
| Property | Description |
|---|---|
| Name | Name of the synonym (usually corresponding to a simplified name of the base object) |
| Code | Code of the synonym |
| Comment | Additional information about the synonym |
| Stereotype | Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined |
| Owner | Name of the synonym owner. You choose an owner from a list of users. A synonym can only have one owner at a time |
| Base Object | Name of the object origin of the synonym. The Ellipsis button displays a selection dialog box that lets you select objects among all the models opened in the current workspace and belonging to the same DBMS family as the current DBMS |
| Visibility | Allows to define a synonym as public (accessible to all database users) or private (available to a specific user) |
| Type | For those DBMS that support it (for example DB2) you can create an alias instead of a synonym. In PowerDesigner synonyms and aliases are managed in the same way whereas their behavior in the database may be different |
For more information on aliases, see the DB2 documentation.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |