List of suggested Exclude Tables and Preserve Data for cloning for SSO
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 07:21 AM
Hi all,
I have searched high and low for this and cannot find any direct answer. The closest I got was a link posted by Aaron that no longer exists:
We use SSO on PROD and I am under the impression that if we clone to a TEST instance, the login method will become the same as PROD and therefore mess it all up. Basically, we need to prevent SSO properties from getting cloned and overwritten.
I know I need to create Preserve Data in the target instance. I have the list of the tables to preserve the Users:
sys_user
sys_user_role
sys_user_group
sys_user_grmember
sys_user_has_role
sys_group_has_role
sys_user_role_contains
What I am asking for is a list of tables I need to create in Preserve Data in the TEST instance to preserve SSO... any help is highly appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 11:32 AM
Please see:
That contains the information on preserving SSO. Trying to preserve users can lead to problems, and may not be necessary, but may work for you using the list of tables you have. If you want to preserve SSO, there should be no need to add those user-related tables to the Data Preservers.
