Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › Define SQL Server Synonyms

Define SQL Server Synonyms

Use the SQL Server Synonym Editor to define synonyms for database objects in a SQL Server 2005/2008 physical model.

To define SQL Server synonyms

1. Click Synonyms on the Database menu.

   The SQL Server Synonym Editor opens.

2. Select the synonym in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new synonym.

   • Name

     Displays the synonym name. You can change the synonym name in this field.

   • Schema

     Specifies the schema in which the synonym is created.

   • Generate

     Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and work with the following option:
   • Object Name

     Defines the base object that the synonym references. Enter the information in this field.

4. Click the Permission tab and work with the following options:

   Note: Click New on the toolbar to create a new permission.

   • Name

     Displays the permission name. Change the name of the permission in this field.

   • Type

     Specifies the permission type. Select the option from the drop-down list.

   • Cascade

     Specifies the cascade action for the permission. Indicates that the permission revoked is also revoked from other principals to which it has been granted by this principal.

   • With Grant

     Specifies if the user can grant this permission to other users or not.

   • Grant As Principal

     Specifies the principal used to acquire the permissions. Select a principal from the drop-down list.

5. (Optional) Click the Comment tab and enter any comments that you want to associate with the synonym.
6. (Optional) Click the UDP tab to work with user-defined properties for the synonym.
7. Click Close.

   The synonym is defined and the SQL Server Synonym Editor closes.