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.

View Properties window: Permissions tab

See also