Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in erwin® Data Modeler › SQL Azure Common Functionality › Define Permissions for an Object in a SQL Azure Property Editor

Define Permissions for an Object in a SQL Azure Property Editor

You can define permissions for certain SQL Azure objects using the Permission tab in the object's property editor. The Permission tab lets you create, edit, or delete permissions for a selected object. For example, if you click the Permission tab in the SQL Azure Table Editor, any permissions that you create, edit, or delete affects the selected table in that editor.

To define permissions for an object in a SQL Azure property editor

1. Open the property editor for the object for which you want to define permissions, and select the object in the Navigation Grid.
2. Click the Permission tab and work with the following options:

   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.

   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 the permission revoked is also revoked from other principals to which it has been granted or denied by this principal.

   With Grant

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

   Grant as Principal

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

3. Click Close.

   Permissions are defined for the selected object and the property editor closes.

More information:

Define SQL Azure Permissions