Granting and revoking schema privileges for user groups

Use the Group page of the Schema Privileges notebook to grant privileges to and revoke schema privileges from user groups.

Fields and controls

Authorities and privileges



To grant groups privileges:

  1. Open the Schema Privileges notebook.
  2. Open the Group page by clicking on the Group tab.
  3. In the Group box, all groups that are currently granted privileges for this object are listed. To add additional groups to this list, click on Add group. The Add Group window opens.
  4. Select one or more groups in the Group box.
  5. To grant or revoke all privileges for the selected groups, click on Grant all or Revoke all.
  6. To grant or revoke individual privileges by column, use the Privileges selection boxes. Click on the down arrow, then select Yes, No, or Grant.
  7. When you have finished changing the privileges for groups, click on Apply. DB2 processes your request.
  8. Click on Cancel to close the Privileges notebook and return to the Control Center.


Related information