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:
- Open the Administration Console.
- Click Access Management > Users.
- Double-click the user account or select the user account from the list and click Change.
- Select Enable in the Account status field.
- 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'
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:
- Start iSeries Navigator from the PC where it is installed.
- Expand the iSeries system. Expand Databases, right-click the Relational Database, and select Run SQL Scripts. The Run SQL Scripts window opens.
- From the Connection menu, select JDBC Setup. Click the Server tab.
- 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.
- Type the preceding SQL statements in the window.