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

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Question:

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?

 

Answer:

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:

Service Desk Manager r14.1 Wiki - Upgrade CA SDM Using the SWING Box Method - Step 2: Prepare the SWING Environment and Replicate Production to SWING

Environment

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