set EMPLOYEE_EXTENDED automatically to all users in IBM Connections

With credits to the author Christoph Stoettner: http://www.stoeps.de/adding-employee_extended-to-all-users/

Here is a 2 step script for enabling the EMPLOYEE_EXTEND role to all users, it will give all users the right to invite external users.

Create a script called employee_extend.sql

connect to peopledb;
EXPORT TO mail.txt OF DEL MODIFIED by NOCHARDEL
select e.PROF_MAIL FROM EMPINST.EMPLOYEE e
    inner join EMPINST.EMP_ROLE_MAP r
    on r.PROF_KEY=e.PROF_KEY
    where r.ROLE_ID!='employee.extended';
connect reset;

Just run it with db2 -tvf employee_extend.sql.

The above script creates a file with users WITHOUT the role. You can use this file to add the role to those users.

Commands for adding the role using the Deployment Manager server:

cd /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin

./wsadmin.sh -lang jython

execfile(“profilesAdmin.py”)

ProfilesService.setBatchRole(EMPLOYEE_EXTENDED, “mail.txt”)

You can create a script on your server and schedule it after the TDI schedule !

Views: 373