How to update Roles of existing user between instances

haruna naka
Tera Contributor

I have two instances and I could migrate "Roles of new user" that created the update set to the other, but I couldn't migrate "Roles of existing user" that created the update set to the other.

If someone knows, please let me know.

Thanks.

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Hi @haruna naka ,

Update set doesn't capture the Users and role.
If we want move the users and role from one instance to another then we have to use import xml.
for that first.
sys_user , sys_user_role, sys_user_has_role, from this three table apply the filter and get your record whatever you want, then click on column level menu and select the Export as XMl.
after that open target instance go to that perticular table for ex. if you want import the user then go to sys_user table and click on column level menu and select import user and uplod the xml files , do the same things for role (sys_user_role) and sys_user_has_role (This table contain the user with roles).
 
Recommendation:-

* Always migrate Group - Role and User - Role mappings records via XML to higher instances

* Now migrate ACLs to higher instances then you can see all the roles to the ACLs over there

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

 

View solution in original post

3 REPLIES 3

Community Alums
Not applicable

Hi @haruna naka ,

Update set doesn't capture the Users and role.
If we want move the users and role from one instance to another then we have to use import xml.
for that first.
sys_user , sys_user_role, sys_user_has_role, from this three table apply the filter and get your record whatever you want, then click on column level menu and select the Export as XMl.
after that open target instance go to that perticular table for ex. if you want import the user then go to sys_user table and click on column level menu and select import user and uplod the xml files , do the same things for role (sys_user_role) and sys_user_has_role (This table contain the user with roles).
 
Recommendation:-

* Always migrate Group - Role and User - Role mappings records via XML to higher instances

* Now migrate ACLs to higher instances then you can see all the roles to the ACLs over there

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

 

I could migrate Users and role through xml.

Thank you for your help @Sandeep Dutta 

Community Alums
Not applicable
Glad to help you !!