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


Materialized View Properties window: Permissions tab

This tab has the following components:

Permissions list   Lists the users who have permissions on the materialized 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 materialized view to other users.

  • Revoke   Revokes permissions from the selected user(s) and removes the user(s) from the Permissions list.

The following lists the possible permissions that a user can have on a materialized view:

  • Select   Allows the user to view data in the view.

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

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

  • Update   Allows the user to update rows in the view.

  • Grant   Allows the user to grant permissions on the view to other users.

  • 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