+

Search Tips   |   Advanced Search


Create users

View the steps to set up users for DB2 to work with WebSphere Portal. Before you begin: You should have completed Installing DB2.


Prerequisites

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

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. The limitations on user names are:

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. Assign an authority for the user. Select Database Administrator Authority.

  5. Click OK.


Parent topic:

Prepare DB2 on AIX for a stand-alone production server


Previous topic:

Installing DB2


Next topic:

Creating remote databases