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:
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 -u 1004 -g db2iadm1 -m -d /db2home/lcuser lcuser -p password
where password is new password for the new user. The command assumes that your DB2 users group is db2iadm1 and that your home directory for DB2 is db2home. If these values are different in your environment, modify the command accordingly.
- Click Start -> Control Panel and select Administrative Tools -> Computer Management.
- From the Computer Management console, select System Tools -> Local Users and Groups.
- Right-click Users and select New User.
- Add a user named lcuser. Enter the required details, including the password. Clear the User must change password at next logon check box. Click Create.
- Click Close.
- Open the Users object, right-click lcuser, and select Properties from the context menu.
- Click the Member Of tab and then click the Add button.
- Type DB2USERS in the Enter the object names to select field, and click OK. 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
Parent topic: Creating databases
Creating multiple database instances
Registering the DB2 product license key
Configuring the DB2 databases for unicode
Creating databases with the database wizard
Creating databases with SQL scripts
Enabling NO FILE SYSTEM CACHING for DB2 on System z
Using the database wizard
Preparing the database wizard
Creating IBM DB2 databases manually