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).
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