How to make sysids similar in nonprod and prod instance for users and group records

[Kishor O]

We want similar sysids for sys_user and sys_user_group records in prod and non-prod instances.

[Animesh Das2 · Accepted solution]

Hi @Kishor O ,

If you want to keep the sys_ids same across environments for 'sys_user' and 'sys_user_group' then only option I can think of is, create the users and groups in prod as there would be jobs to pull data from 3rd party applications and all and then export the xmls for those two tables and import those in lower environments.

We follow this approach in our client environment.

If you create new records by any other means they would be having different sys_ids.

If this address your question, please mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das

[Bert_c1]

You can do what Animesh Das2 suggests. If you want reference fields to sys_user and sys_user_group on the many tables with those reference fields to refer to the new records in both tables, the Clone prod over the sub-prod instance.