Grant table access permission to users, groups, or roles.
Table owners and database owners can grant database object permissions on
a table.
- In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
- In the left pane of the Administration Console, expand , then choose one of the following:
- Select the table on which to set permissions.
- Select Properties.
- Select Permissions.
- Click Grant to grant access permissions for the selected object.
You see the Grant Permission 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.