Table property sheet: Permissions tab

The Permissions tab of the Table property sheet 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.

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.

See also