Creating a dedicated DB2 user

Create a dedicated IBM® DB2® database user named lcuser with restricted privileges.

About this task

Perform this task to create a DB2 database user, called lcuser, with a limited set of privileges. The scripts that are provided with IBM Connections grant the appropriate rights to lcuser and are written with the assumption that the user name is lcuser. Always use lowercase characters for this user name.

To create a dedicated DB2 database user named lcuser, complete the following steps:

Procedure

Choose your operating system:
  • AIX® or Linux™:
    • Log into the DB2 server as the root user, and then type the following command to create a new user:
      useradd -g db2iadm1 lcuser
echo "lcuser:password" | chpasswd

      where password is new password for the new user. You can specify a home directory other than the default by entering useradd -g db2iadm1 -m -d /db2home/lcuser lcuser.

  • Windows
    1. Click Start > Control Panel and select User Account > Add or Remove User Accounts > Create a New Account.
    2. Enter lcuser for the name of the new account. The account type should be administrator.
    3. Click the newly created account, click Create a Password to give a password to the new account.
    4. Right-click Computer, select Manage in the menu.
    5. Select System Tools > Local Users and Groups > Users, right-click lcuser, and then select Properties.
    6. In the popup window select Member Of tab, click Add and enter DB2USERS in the Enter the object name to select field.
    7. Click Check Names and then click OK.
    8. Click OK again to save your changes.
      Note: If the DB2USERS group is not found, extended security for DB2 on Windows™ might not be enabled. See the DB2 documentation for information about Extended Windows security using DB2ADMNS and DB2USERS groups.

What to do next

For more information about granting privileges to users, go to the DB2 information center.