Create a dedicated IBM® DB2® database user named lcuser
with restricted privileges.
About this task
Perform this task to create a DB2 database user with a limited set of privileges. When you create the new user, name it lcuser
. The scripts that are provided with IBM Lotus® 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 commands to create a new user:
When prompted for the new password, enter it and then confirm it.
- 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
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