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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|