Create users

 

+

Search Tips   |   Advanced Search

 

Prerequistie: Install DB2

For all databases, use one user with administrative rights on the operating system and the DB2 installation.

This user can be the database administrative user that is created automatically by the DB2 installation program. This user is the database configuration user that will be used for configuration tasks: creating database tables and performing database transfer. If you choose to have WebSphere Portal also create the databases, the database user should be given SYSADM rights.

Common user names created by DB2 on installation are...

• db2inst1
• db2admin

You can assign any user name as long as it has administrative access and follows the limitations listed here.

Do not change the user name after creating it.

The limitations on user names are:

• User names can contain one to 20 characters.

• Group and instance names can contain one to eight characters.

• Names cannot be any of the following: users admins guests public local

• Names cannot begin with: IBM SQL SYS

• Names cannot include accented characters.

• Create users in an environment that has the same settings as the actual runtime environment.

  For example, avoid creating a user in an English environment if you plan to use that user in a Turkish environment.

Basic steps to create new users and grant privileges...

1. From the DB2 Control Center, expand the object tree until you find the DB Users folder.

2. Right-click the DB Users folder and select Create/Add.

3. In the User name field, type a user ID.

4. Assign an authority for the user. Select Database Administrator Authority.

5. Click OK.

Parent topic:

Configure WebSphere Portal to use DB2

Previous topic:

Installing DB2

Next topic:

Creating remote databases

Related information

DB2 product documentation