Adding a user account for the manager on WebSphere Application Server Community Edition

If you use the default user security configuration for the manager on WebSphere® Application Server Community Edition, user security information is stored in a database. You can use SQL commands to maintain user accounts in this database. Use this task to create a user account on this database.

Use this topic to add user accounts for the manager only if you are using the default user security configuration for the manager. The default user security configuration might not be secure enough for production use.

For some product solutions, the manager might support the creation of user accounts that are based on user accounts on an external system. For these product solutions, create user accounts through the manager user interface so that you can fully use the integration with the external system. If you do not use such a product solution, create new user accounts by following the security environment that has been established for the application server.

Before you can add a user account, deploy the manager Web archive (WAR) file to WebSphere Application Server Community Edition.

The version of WebSphere Application Server Community Edition that is delivered with the manager is available only in English. You must configure this version of WebSphere Application Server Community Edition by using an English user interface. However, when you use the manager, the language setting of the browser determines the language of the manager user interface. The language setting of the browser also determines the language of the messages that are received from the management server and proxy.

Use the Administrative Console of WebSphere Application Server Community Edition to add a user account for the manager. The default location of the Administrative Console is http://hostname:8080/console, where hostname is the host name of the computer on which WebSphere Application Server Community Edition is installed.

To add a user account for the manager by using the Administrative Console of WebSphere Application Server Community Edition:

  1. Click DB Manager.
  2. In Use DB, select optimConsoleDB.
  3. Enter the following SQL commands into SQL Command/s.
    INSERT INTO CONSOLE2.OOB_USER values(userid,username,password);
    INSERT INTO CONSOLE2.OOB_USER_ROLE values(userid,roleid,rolename);
    • The integer value userid uniquely identifies the user.
    • The varchar value username specifies the user name. The user name is typically a string value.
    • The varchar value password specifies the user password. The user password is typically a string value.
    • The integer value roleid and the varchar value rolename are values that correspond with each user role ID and user role name:
      • The user role ID 0 and user role name admin correspond with the admin (manager administrator) user role.
      • The user role ID 1 and user role name dba correspond with the dba (database administrator) user role.
      • The user role ID 2 and user role name lob correspond with the lob (line-of-business) user role.
      • The user role ID 3 and user role name designer correspond with the designer user role.
      • The user role ID 4 and user role name operator correspond with the operator user role.
  4. Click Run SQL.
For example, the following SQL code creates a user ID with the admin user role and a user ID with the operator user role. Both user IDs use passw0rd as the password.
INSERT INTO CONSOLE2.OOB_USER values(10,'administrator','passw0rd');
INSERT INTO CONSOLE2.OOB_USER_ROLE values(10,0,'admin');
INSERT INTO CONSOLE2.OOB_USER values(11,'user14','passw0rd');
INSERT INTO CONSOLE2.OOB_USER_ROLE values(11,4,'operator');