Change the SYS and SYSTEM password for Harvest Database

Products

• CA Harvest Software Change Manager

Issue/Introduction

Database admin is planning to change the SYS and SYSTEM password for the Harvest Database.

Is there any impact to the Harvest application due to this password change for the users SYS and SYSTEM?

Environment

CA Harvest Change Manager

Oracle Database

Resolution

Usually the Harvest database schema should be under another userid - normally the "harvest" user.  Therefore, there would be no impact to the Harvest application.

If the "system" or "sys" userid is the schema owner for Harvest, then the Harvest tables will be owned by that user.

To verify, you can query the system view "dba_tables" to see what userid owns table "hartableinfo" to confirm which database user is used with Harvest.