To grant/revoke privileges on tables:

  1. Select the table in which you want to add the privileges of which are to be granted to the other users/groups. The Schema page is displayed.

  2. Click the Permissions tab at the top of the window. The Permissions page is displayed.

  3. Click Modify. The Confirm and Cancel buttons are now active

  4. Select one of the permissions in the cells for the user/group.

  5. To revoke a privilege, click any of the checked columns.

  6. To grant or revoke permission on columns, click the Column Permission option button. The window appears as below.

  7. Select any of the following permissions in the cells for your user/group:

  8. To revoke a privilege, click any of the checked columns.

  9. Click Confirm to execute all changes.


Related topic:

Granting/Revoking Table Privileges
Granting and Revoking Object Privileges