Wednesday, February 18, 2015

How to recreate some deleted internal user in IBM BPM 7.5-8.0

In IBM BPM 7.5-8.0 internal users are stored in BPMDB.
If you delete some of them - the full information about it will not delete from the database and you can to recreate it.
The information about internal users are stored in two tables:lsw_usr_xref and lsw_usr
and this information is deleted from lsw_usr only.

If you need to recreate some deleted internal user (in 7.5 and 8.0) - you need make three steps:

Step 1. To know its ID (my user, for example, has the name test222):
 select user_id from bpmdb.lsw_usr_xref where user_name='test222';
 
 USER_ID
 ----------
 3452

Step 2. To know a hash of some user password what you know (tw_admin, for example). 
 select passwd from bpmdb.lsw_usr where user_name='tw_admin';
 
 PASSWD --------------------------------------------------------------
 SHA-256:1:e5mmRR6LmZnhOyY4:liy0F81+IFvTiSwiBEtaORPbcYvLPvEn9D8vxsmpVzQ=

Step 3. To recreate user using our data.
INSERT INTO "BPMDB"."LSW_USR" (USER_ID, USER_NAME, PASSWD, 
FULL_NAME, IS_DISABLED, LAST_LOGIN_DATETIME) 
VALUES ('3452', 'test222', 
'SHA-256:1:e5mmRR6LmZnhOyY4:liy0F81+IFvTiSwiBEtaORPbcYvLPvEn9D8vxsmpVzQ=',  
'test222', 'F', TO_DATE('18.02.15', 'DD.MM.RR'))

So now you can to enter the system using test222 username and the password of tw_admin user.

No comments:

Post a Comment