Changing database authorities

Use the Database page of the Change User notebook to change a user's authorities on a database.

Fields and controls

Authorities and privileges

To change a user's authorities on a database:

1. Open the Change User notebook.

2. Under Choose the appropriate authorities to grant to the selected user, indicate which authority or authorities you want to change.

3. Click on Apply. The authority or authorities are changed.

4. Optional: Grant and revoke privileges on one or more of the following kinds of objects, in any order:
   • Schemas
   • Tables
   • Indexes
   • Views

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

Related information

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