Changing table privileges

Use the Table page of the Change Group notebook to change a group's privileges on tables.

Before you begin...

To change a group's privileges on tables:

1. Open the Change Group notebook.

2. Open to the Table page by clicking on the page's tab.

3. Perform one or more of the following operations:

   • Operations involving tables on which the group has one or more privileges:

     • Grant all additional privileges at the same time.

     • Grant additional privileges or change Grant options individually.

     • Revoke all privileges at the same time.

     • Revoke privileges individually.

   • Operations involving tables that the group has no privileges on:

     • Grant all privileges at the same time.

     • Grant privileges individually.

4. Optional: Grant and revoke one or more of the following kinds of authorizations, in any order:
   • Database authorities
   • Schema privileges
   • Index privileges
   • View privileges

5. Click on Close to close the Change Group notebook.

Related information

• Controlling database access -- See the Administration Guide
• GRANT and REVOKE statements -- See the SQL Reference
• Authorizations and authorization names for users and groups

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

[ DB2 List of Books | Search the DB2 Books ]