Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Define SQL Azure Permissions

Define SQL Azure Permissions

Use the SQL Azure Permission Editor to define permissions for a database in a SQL Azure physical model.

To define permissions for SQL Azure

1. Click Target - SQL Azure, Permissions on the Model menu.

   The SQL Azure Permission Editor opens.

2. Select the permission 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 permission. Use the Enter filter text box to filter a very large list of permissions to quickly locate the one that you want to define.

   Name

   Displays the permission name. You can change the permission name 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 other users or not.

   Grant as Principal

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

3. Click the General tab and work with the following options:

   Permissions to Grant

   Specifies the permissions that are granted to the selected permission. Select or clear check boxes for specific permissions.

   Principals to Grant

   Specifies the principals that are granted to the selected permission. Select or clear check boxes for specific principals.

   Note: Click an icon to open one of the security editors (User ID or Database Role ) to further define a principal. At this time, the Application Role principal is not supported.

   Logins to Grant

   Specifies the logins that are granted to the selected permission.

   Note: Click the Login Editor icon to open the SQL Azure Login Editor to further define a login.

4. (Optional) Click the Comment tab and enter any comments that you want to associate with the permission.
5. (Optional) Click the UDP tab to work with user-defined properties for the permission.
6. (Optional) Click the Notes tab to view history information and view or edit user notes.
7. Click Close.

   The permission is defined and the SQL Azure Permission Editor closes.

More information:

Add a Comment in a Property Editor