Export User and Groups from Camunda DB


#1

I have a large number of users and groups created in Camunda DB. How can I export these user/groups out of DB so that I can reuse that to create users/groups in other env without need to go through the Cockpit UI?


#2

I think using your database’s backup/restore tools is the best approach.

Cheers,
Thorben


#3

@thorben

Are there any specific tables I can backup and restore? I don’t want to do for all the tables as it may copy the process instance data s well?

Thanks


#4

Hi @adat,

Users are stored in ACT_ID_USER and groups are in ACT_ID_GROUP. Assignments of users to groups are in ACT_ID_MEMBERSHIP.

Cheers,
Thorben