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.

Before you begin...

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 Close to close the Add User 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 ]