Table Properties window: Permissions tab

This tab has the following components:

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

To grant or revoke permissions, 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 table to other users.
Revoke Revokes permissions from the users and removes them from the Permissions list.

Select Shows whether the select permissions for the user applies to all columns or a subset of columns. Click Change to grant Select permissions for a subset of columns.

Update Shows whether the update permissions for the user applies to all columns or a subset of columns. Click Change to grant Update permissions for a subset of columns.

References Shows whether the reference permissions for the user applies to all columns or a subset of columns. Click Change to grant Reference permissions for a subset of columns.

Change Click Change to grant select, update, or reference permissions for a subset of columns.

Table Properties window: Permissions tab

See also