Create a dedicated DB2 user
Create a dedicated DB2 database user named lcuser with restricted privileges.
Perform this task to create a DB2 database user, called lcuser, with a limited set of privileges. The scripts provided with Connections grant the appropriate rights to lcuser and are written with the assumption the user name is lcuser. Always use lowercase characters for this user name.
To create a dedicated DB2 database user named lcuser:
Choose the 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. We can specify a home directory other than the default by entering useradd -g db2iadm1 -m -d /db2home/lcuser lcuser.
- Windows
- Click Start > Control Panel and select User Account > Add or Remove User Accounts > Create a New Account.
- Enter LCUSER for the name of the new account. The account type should be administrator.
- 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.
- Select Configuration > Local Users and Groups > Users, right-click LCUSER, and then select Properties.
- In the popup window select Member Of tab, click Add and enter DB2USERS in the Enter the object name to select field.
- Click Check Names and then click OK.
- Click OK again to save the changes.
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:
Create databases
Related: