Resetting an administrator account

If a WebSphere Commerce account gets locked or disabled for some reason, you can unlock or enable it as follows:

If the account is not a Site Administrator's account:

  1. Open the Administration Console.
  2. Click Access Management > Users.
  3. Double-click the user account or select the user account from the list and click Change.
  4. Select Enable in the Account status field.
  5. Click OK.

Resetting a Site Administrator's account

If the account is a Site Administrator's account or any other user account, run the following SQL statements from either a DB2 command window, or an SQLPlus prompt (for Oracle databases):

CONNECT TO db_name [USER user_id USING password]
UPDATE USERREG SET STATUS=1, PASSWORDRETRIES=0 WHERE LOGONID='logonId'

where

db_name
Is your WebSphere Commerce database name (for example, MALL).
user_id
Is the database administrator user ID for the database.
password
Is the password corresponding to the database administrator user ID.
logonId
Is the user ID of the account that you want to reset (for example, wcsadmin).

For example, to reset the wcsadmin account, you can issue the following SQL statements if you are logged onto your system as the database administrator user ID:

CONNECT TO mall 
UPDATE USERREG SET STATUS=1, PASSWORDRETRIES=0 WHERE LOGONID='wcsadmin'

i5/OSiSeries To enter SQL statements, you can use either the DB2/400> Query Manager and the SQL development kit, or you can use iSeries Navigator. To use IBM iSeries Access to perform database queries:

  1. Start iSeries Navigator from the PC where it is installed.
  2. Expand the iSeries system. Expand Databases, right-click the Relational Database, and select Run SQL Scripts. The Run SQL Scripts window opens.
  3. From the Connection menu, select JDBC Setup. Click the Server tab.
  4. In the Default libraries field, erase any existing values and enter the name of the database schema of your instance. By default the schema name is the name of the instance. Click OK to save your changes.
  5. Type the preceding SQL statements in the window.

Feedback