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):
So now you can to enter the system using test222 username and the password of tw_admin user.
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