Is it necessary to fix the orphaned users for Oracle database?
search cancel

Is it necessary to fix the orphaned users for Oracle database?

book

Article ID: 36987

calendar_today

Updated On:

Products

CA Service Desk Manager CA Service Management - Service Desk Manager

Issue/Introduction

The step 5 of Swing Box method "Step 2 - Prepare the SWING Environment and Replicate Production to SWING" says:

5.Execute the stored procedure in SQL to fix the orphaned users which are created when restoring a database from one SQL instance to another. Example:  sp_change_users_login 'AUTO_FIX','ServiceDesk'.

Is it necessary to address to fix the orphaned users on the Oracle server?

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component:

Resolution

No, you do not have to follow the step 2 - 5 "Execute the stored procedure in SQL to fix the orphaned users..." on the Oracle server.

Additional Information

CA SDM Swing-Box Migration using Production Replica to Upgrade to CA SDM 17.4