Home

 

Create a dedicated DB2 user

 

+

Search Tips   |   Advanced Search

 

Create a dedicated DB2 database user named lcuser with restricted privileges.

This is an optional procedure. Perform it only if you want to create a DB2 database user with a limited set of privileges.

This procedure applies only to DB2 databases.

When you create the new user, name it lcuser. The scripts that are provided with 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.

• AIX or Linux

  • Log into the DB2 server as the root user, and then run...

    useradd lcuser
    passwd lcuser

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

• Windows

  1. Click...
     Start | Control Panel and select Administrative Tools | Computer Management | System Tools | Local Users and Groups | Users (right-click) New User

  2. 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.

  3. Click Close.

  4. Open the Users object, right-click lcuser, and select Properties from the context menu.

  5. Click the Member Of tab and then click the Add button.

  6. Type DB2USERS in the Enter the object names to select field, and click OK. Click OK again to save your 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.

 

Related tasks

Create databases
Create multiple database instances
Register the DB2 product license key
Create databases with the database wizard
Create databases with SQL scripts
Populate the Profiles database
Create IBM DB2 databases manually
Prepare the database wizard
Create databases with the database wizard