I have managed to get my autosys password and database password out of sync. Is it possible to synchronize

Document ID : KB000014848
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

The "autosys" user's password (autosys_secure) and the database password are out of sync. Is there a way to get them back in sync?

Environment:
WAAE 11.3.6 Release
Answer:

The recommended solution for changing the "autosys" user's password is to use "autosys_secure".

If for whatever reason the password has been changed directly in the database or is no longer in sync with the database password, you can use the following steps to synchronize them:

  1. In your database, change the password for "autosys" user to "autosys".

  2. Login to the database as the "autosys" user and run the following sql query:

    update alamode set str_val='aDc?C)D~FDFbH{h>' where type='password';


  3. You should now be able to use autosys_secure to change the password to another string using "autosys" as the current password.