Granting and revoking database authorities for users

Use the User page of the Authorities notebook to grant authorities to and revoke database authorities from users.

Before you begin...

To grant users authorities:

1. Open the Authorities notebook.

2. In the User box, all users that are currently granted authorities for this database are listed. To add additional users to this list, click on Add user. The Add User window opens.

3. Select one or more users from the User box.

4. To grant or revoke all authorities for the selected users, click on Grant all or Revoke all.

5. To grant or revoke individual authorities by column, use the Authorities selection boxes. Click on the down arrow and select Yes or No.

6. When you have finished changing the authorities for users, click on Apply. DB2 processes your request.

7. Click on Close to close the Authorities notebook and return to the Control Center.

Related information

• Granting and revoking database authorities for user groups

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

[ DB2 List of Books | Search the DB2 Books ]