Appreciations accepted

Vladlen Litvinov, the author: If you have some job offer for me, I'm ready to discuss it. View Vladlen Litvinov's profile on LinkedIn

Password

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