Portal, Express Beta Version 6.1 Operating systems: i5/OS, Linux,Windows

Create users

This section provides information on setting up users for DB2 to work with WebSphere Portal Express.

Prerequisites

Installing DB2

Creating remote databases

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. If you choose to have WebSphere Portal Express create the databases, the database user should be given SYSADM rights.

A common user name is db2inst1, but 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.

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

Following are the basic steps to create new users and grant privileges. For more information, refer to the DB2 product documentation.

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. The Create DB User notebook opens.
3. In the User name field, type a user ID.
4. Click the tab for the type of object for which you want to grant privileges to the user ID. The privileges can be altered pertaining to the user.
5. Click OK.