Alter relational store account passwords

ArcGIS Data Store randomly generates usernames and passwords for the following relational store accounts:

• The database administrator user in the relational store

• The database user that connects and replicates data to the standby machine

• The geodatabase administrator

• The database user under whose schema hosted feature layer data is stored (the managed user)

If your site requires you to change passwords on a regular basis for security reasons, follow these steps:

1. Sign in to the primary machine of the ArcGIS Data Store relational store and run the listadminusers and listmanageduser utilities to obtain the existing credentials.

2. Using the information returned by the utilities you ran in the previous step, run the changepassword utility to update the password for each account.

   Passwords are updated for one account at a time; therefore, if you update the password for all four accounts, you'll run the changepassword utility four times.

   In the following example, the password for account ckop99_ql is updated:

   ./changepassword.sh ckop99_ql Wdnh2vam2fdm;opitmiotu

   changepassword ckop99_ql Wdnh2vam2fdm;opitmiotu

   Tip:

   If you need to script password changes, include a flag to suppress the confirmation prompt, as in the following example:

   ./changepassword.sh ckop99_ql Wdnh2vam2fdm;opitmiotu --prompt no

   Tip:

   If you need to script password changes, include a flag to suppress the confirmation prompt, as in the following example:

   changepassword ckop99_ql Wdnh2vam2fdm;opitmiotu --prompt no