Create a dedicated DB2 userCreate a dedicated IBM DB2 database user named lcuser with restricted privileges.
About this taskPerform 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 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...
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 nextFor more information about granting privileges to users, go to the DB2 information center.
Parent topicCreate databases
Create multiple database instances
Registering the DB2 product license key
Create databases with the database wizard
Create databases with SQL scripts
Enable NO FILE SYSTEM CACHING for DB2 on System z
Use the database wizard