Notifications

257 views

Description


Occasionally you would like to have the roles you have available on your source instance on your target instance. This article describes a few options to do just that.

NOTE:

Data preservers are primarily intended to preserve system settings and themes, such as instance-specific authentication settings. Do not use data preservers to transfer large sets of data, such as user groups. If you must preserve table data such as users, groups, and roles, consider exporting the records to a file and importing it after the clone is complete. More information can be found in our documentation topic: Data preservation on cloning target instances.

 

 

Procedure


Test Case

Preserve the ‘itil’ role when cloning. This is the link to the ‘itil’ role:

/nav_to.do?uri=sys_user_role.do?sys_id=282bf1fac6112285017366cb5f867469

OPTION 1: On target clone instance, export data from various tables to .xml, perform clone, then import all .xmls back onto the target clone instance. You can use these links:

  • /sys_user_role_list.do?sysparm_query=name%3Ditil
  • /sys_user_has_role_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
  • /sys_user_role_contains_list.do?sysparm_query=contains%3D282bf1fac6112285017366cb5f867469%5E

NOTE: Depending on the testing being performed and customizations to roles and ACLs, these tables will likely be optional:

  • /sys_app_application_list.do?sysparm_query=roles%3Ditil
  • /sys_app_module_list.do?sysparm_query=roles%3Ditil
  • /sys_security_acl_role_list.do?sysparm_query=sys_user_role%3D282bf1fac6112285017366cb5f867469%5E
  • /pa_dashboards_permissions_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
  • /sys_embedded_help_role_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
  • /sys_group_has_role_list.do?sysparm_query=role%3D282bf1fac6112285017366cb5f867469%5E
  • /sys_ui_action_role_list.do?sysparm_query=sys_user_role%3D282bf1fac6112285017366cb5f867469%5E

OPTION 2: Create table exclusions and data preservers.

On the source clone instance, create data preservers (see the documentation topic in the "Note" above).

You can know request a clone. The final result will be all roles were cloned over to the target clone instance. However, the ‘itil’ role on the target instance remains the same.

Applicable Versions


All

Additional Information


Depending on the size of a database, this can cause clone performance issues and lead to the clone process to fail completely.

KB0717012 - Clone results based on Exclusion and Preserver configuration

KB0716394 - Preserve the Users [sys_user] table when cloning

Exclude a table from cloning

Data preservation on cloning target instances

Article Information

Last Updated:2019-03-08 15:43:20
Published:2019-03-08