Previous Topic: SQL Azure Common FunctionalityNext Topic: Define the SQL Code 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