How to handle SAP ASE database user's password

When an ASE database user’s password changes, update the password in Delphix using the following options:

1. SAP ASE Information - If the SAP ASE instances are discovered automatically, go to the Manage > Environment screen and update the SAP ASE database user's password under the SAP ASE Information.

2. Command line interface (CLI) - If the SAP ASE instances were discovered manually, each SAP database user's password in the repository must be updated through the CLI using these commands:

   Copy

   test18.dcol2> /repository
   
   test18.dcol2 repository> select TESTRH83
   
   test18.dcol2 repository 'TESTRH83'> update
   
   test18.dcol2 repository 'TESTRH83' update *> set credentials.password=sybase
   
   test18.dcol2 repository 'TESTRH83' update *> commit

   Once the database user's password is updated via CLI, user can run enable, disable, SnapSync, and ValidatedSync operations without any authorization error.

3. dSource Configuration - Go to the dSource’s Configuration > Source tab, update SAP database user's password. If the SAP ASE database user's password is not updated, the ValidatedSync operation fails.

   Even if the same ASE user is configured in all three locations, the password must still be updated separately in each location, as Delphix treats them as distinct references.