Defining a new database user to DB2

You can use the Database page of the Add User notebook to define a new user of a database to DB2.

Fields and controls

Authorities and privileges

To define a new user of a database:

1. Open the Add User notebook.
2. Use the User box to specify the user's authorization name.
3. Grant this user one or more of the following types of authorizations, in any order:
   • Database authorities
   • Schema privileges
   • Table privileges
   • Index privileges
   • View privileges
4. Click on Cancel to close the Add User notebook.

Related information

• Add 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