topic Re: How can i customize ACT_ID_USER table? in Alfresco Forum

How can i customize ACT_ID_USER table?

vamsinipun — Wed, 27 Sep 2017 07:22:24 GMT

Hi Team, I am using activiti process in my spring project. In my spring project already i have users table but activiti given ACT_ID_USER table. is it possible to use my spring table instead of ACT_ID_USER?if not possilbe i will maintain both tables. any solution for this?

Re: How can i customize ACT_ID_USER table?

fegor — Wed, 27 Sep 2017 15:41:58 GMT

Why do not use LDAP?

Re: How can i customize ACT_ID_USER table?

vamsinipun — Thu, 28 Sep 2017 05:03:50 GMT

Thank you for your reply. please share any link about that.

Re: How can i customize ACT_ID_USER table?

fegor — Thu, 28 Sep 2017 07:57:07 GMT

1. Install OpenLDAP or other

2. Create your users in this ldap with fields as you need (schemas)

2. Configure your Activiti for autentication in ldap

One tutorial for config for Activiti in LDAP by Thys Michels: Activiti BPM Tutorial – LDAP | Thys Michels Blog

Re: How can i customize ACT_ID_USER table?

vamsinipun — Thu, 28 Sep 2017 10:02:42 GMT

Sorry. it is not full fill my requirement. I am using spring security and created my own mysql user table. is there any possibility to use my own mysql user table?

Re: How can i customize ACT_ID_USER table?

fegor — Thu, 28 Sep 2017 10:55:51 GMT

I think is very hard but if you modify the Activiti users table and appended new fields... the problem is recover this information.

Re: How can i customize ACT_ID_USER table?

richard9527 — Thu, 26 Oct 2017 13:27:27 GMT

By the way, for the sake of security, the database of my company disable all the adhoc query and only support procedure.In this state, is the only way to rewrite all the service?

Re: How can i customize ACT_ID_USER table?

ryandawson — Wed, 06 Dec 2017 10:11:21 GMT

I guess you're using v5 or v6. You could consider implementing a custom IdentityService - see https://blog.canang.com.my/2016/05/12/custom-identityservice/ or GitHub - qbast/activiti-keycloak: Integration of activiti users and groups with keycloak . That is suggested in , which seems to be much the same question.

Re: How can i customize ACT_ID_USER table?

vgaur — Sun, 10 Dec 2017 08:27:43 GMT

As Ryan suggested above you can extend UserEntity manager and create your own provider which can look into your table and provide user info.

org.activiti.engine.impl.persistence.entity.UserEntityManager

public class CustomUserEntityManager extends UserEntityManager{
//Your implementation by going through your user table
}

You can then create a factory implementation like this

public class CustomUserEntityManagerFactory implements SessionFactory {

@Override
  public Class<?> getSessionType() {
     return UserIdentityManager.class;
  }

@Override
  public Session openSession() {
    CustomUserEntityManager aUserEntityManager = new CustomUserEntityManager();
   return (Session) aUserEntityManager;
  }
}

and then can inject this is process configuration using

processEngineConfiguration.setCustomSessionFactories(customSessionFactory)

Thanks

-Vishal