How to preserve data during cloning in lower environments.

[deepum]

Hello all,

I have users in Lower environments who have roles only in lower environments, which we use for testing purposes. During the clone, the PROD data is being cloned and the users are losing their roles and being replicated as in PROD. is there a way to preserve the data (a few roles) in lower instances so that we don't need to provide the users the roles in lower environments? I know that I can keep XML of the data but are there any other best practices? 

Any help appreciated. 

Thanks!! 

[Anshu_Anand_]

what you want?

all 8k users +100 users in low environment?

[deepum]

Yes, those 100 users are a part of 8k users. I want the roles of those 100 users in lower environments preserved during the clone. I don't want any data to be missed. From the support article, there is no scenario that matched my requirement. Can this be achieved by any coding? any inputs will be helpful.

Thanks!

[Anshu_Anand_]

For roles, you can preserve table sys_user_has_role

There are 2 ways roles are assigned directly to user or via groups.

In order to not miss anything preserve these ones with conditions:-

sys_user_has_role

sys_user_group where the users resides

sys_user_grmember

sys_group_has_role

If its helpful, please mark answer as correct