Granting and revoking schema privileges for user groups

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

Before you begin...

To grant groups privileges:

1. Open the 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 Close to close the Privileges notebook and return to the Control Center.

Related information

• Granting and revoking schema privileges for users

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]