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

Friday, April 25, 2014

How to add some user to some group in IBM BPM through DB

Sometimes you need to add some user to some group in BPM.
You can do this through admin console certainly.
But imagine that you have not any access to admin console.

This SQL query helps you to solve this issue:

INSERT INTO "BPMDB"."LSW_USR_GRP_MEM_XREF" (USER_ID, GROUP_ID) VALUES ((select user_id from bpmdb.lsw_usr_xref where user_name='UserName'), (select group_id from bpmdb.lsw_usr_grp_xref where group_name='GroupName')); 

We work with our BPMDB (use here the name of your own BPM database).
We take IDs of our user and our group from appropriate tables and insert them into third table.

It works in 7.5-8.5 (but I think in Lombardi Edition too).

No comments:

Post a Comment