Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows


View Properties window: Permissions tab

This tab has the following components:

Permissions list   Lists the users who have permissions on the view. If you want to add users to the list, click Grant. To remove a user from the list, select the user, and then click Revoke. You can select multiple users by holding Shift while you click.

To grant or revoke permissions for a specific user, click the fields beside each user. Double-clicking (so that a check mark and two + signs appear) gives the user grant options.

  • Grant   Displays the Grant Permission window, which lets you grant permissions on the view to other users.

  • Revoke   Revokes permissions from the users and removes them from the Permissions list.

The following lists the possible permissions that the consolidated user can have:

  • Select   Allows the user to view information in the view. If column names are specified, the users are allowed to view only those columns.

  • Insert   Allows the user to insert rows into the named view.

  • Delete   Allows the user to delete rows from the named view.

  • Update   Allows the user to update rows in the view. If column names are specified, the user can update only those columns.

  • Grant   Grants the specified permission for the selected user.

  • Grant with grant option   When the Grant With Grant Option is specified, then the selected user is also given permission to grant the same permissions to other users. If a group is given this permission, its members do not inherit the permission.

See also