how to sync user,group and role Production To Dev Instance

[cha08]

Hi All,

I'm looking sync user , group and roles from Production and QA.

Because daily creating new user adding groups and roles in the production again need to re-create in the development instance.

whether it can be automated task using the script by scheduling job/business script running the script weekly or monthly and also

user will be created specific domain or company.

Thanks in advance.

Regards,

Charan

[SanjivMeher]

Hi Charan,

This should be covered as part of the cloning process. After every major release you should be doing a clone from PROD to DEV, which should replicate your current users and groups

[cha08]

Hi Sanjiv,

Thanks for reply.

we don't want to replicate entire production as development instance.

only need to replicate the new user's and its related group and roles where added to new user's.

Thanks,

Charan

[SanjivMeher]

Cloning periodically is a good practice.

I dont think you can do anything other then taking an xml export of sys_user table, sys_user_group, sys_user_grmember, sys_user_has_role and sys_user_role and import it to QA or DEV.

[ankit_sharma487]

Then the same ldap integration must be done in dev