Creating a dedicated DB2® user

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

About this task

This task is optional if you plan to use the same database instance and user from the IBM® Connections installation.

Perform this task to create a DB2® database user with a limited set of privileges. Name the new user docsuser. The appGrants.sql provided with HCL Docs grant the appropriate rights to docsuser and are written with the assumption that the user name is docsuser.

If there is a special requirement to use a different user name instead of docsuser to access to the HCL Docs application, you must manually update the appGrants.sql to reflect the change. You can refer to Creating the HCL Docs databases to obtain the script, which is contained in the /DocsApp/setupDB directory. You also must provide the user name and password in the Database Server configuration panel of the HCL Docs GUI Installer.

Procedure

  • AIX® or Linux:
    1. Log in to the DB2® server as the root user, and then type the following commands to create a user:
      • useradd -g db2iadm1 docsuser. (db2iadm1 refers to the DB2® user group.)
      • passwd docsuser

      When prompted for the new password, enter it and then confirm it.

  • Windows:
    1. Click Start > Control Panel and select Administrative Tools > Computer Management.
    2. From the Computer Management console, select System Tools > Local Users and Groups.
    3. Right-click Users and select New User.
    4. Add a user named docsuser. Enter the required details, including the password. Clear the User must change password at next logon check box. Click Create.
    5. Click Close.
    6. Open the Users object, right-click docsuser, and select Properties from the menu.
    7. Click the Member Of tab and then click Add.
    8. Type DB2USERS in the Enter the object names 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 for the DB2ADMNS and DB2USERS groups.

      For detailed information, see the IBM® DB2® 10.1 Knowledge Center.