Changing schema privileges

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

Fields and controls

Authorities and privileges

To change a group's privileges on schemas:

1. Open the Change Group notebook.

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

3. Perform one or more of the following operations:

   • Operations involving schemas 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 schemas 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
   • Table privileges
   • Index privileges
   • View privileges

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

Related information

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