Grant table access permission to users, groups, or roles.
Table owners and database owners can grant database object permissions on
a table.
- Select , then choose one of the following:
- Select the table on which to set permissions.
- Select Properties.
- From the Table Properties window, select .
You see the Permissions window.
- Click Grant to grant access permissions for the selected table.
You see Permissions wizard.
- Select the type of grantee:
- Select one or more grantees.
- Select the columns to set permissions.
- Select the types of permissions allowed for the selected grantees.
- (Optional) Click Summary to verify your selected options.