Define SQL Azure Synonyms
SQL Azure supports the three-part name format database_name.[schema_name].object_name when the database_name is the current database or the database_name is tempdb and the object_name starts with #.
Note: SQL Azure does not support four-part names.
Use the SQL Azure Synonym Editor to define synonyms for database objects in a SQL Azure physical model.
To define SQL Azure synonyms
The SQL Azure Synonym Editor opens.
Note: Click New on the toolbar to create a new synonym. Use the Enter filter text box to filter a very large list of synonyms to quickly locate the one that you want to define.
Displays the synonym name. You can change the synonym name in this field.
Specifies the schema in which the synonym is created.
Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.
Defines the base object that the synonym references. Enter the information in this field.
Note: Use the toolbar on this tab to create a new permission, delete a selected permission, or open the SQL Azure Permission Editor to work with permission properties.
Displays the permission name. Change the name of the permission in this field.
Specifies the permission type. Select the option from the drop-down list.
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.
Specifies if the user can grant this permission to other users or not.
Specifies the principal used to acquire the permissions. Select a principal from the drop-down list.
The synonym is defined and the SQL Azure Synonym Editor closes.
Copyright © 2017 erwin Inc.
All rights reserved.
|
|