ArcGIS Data Store randomly generates usernames and passwords for the following relational data store accounts:
- The database administrator user in the relational data 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:
- Sign in to the primary machine of the ArcGIS Data Store relational data store and run the listadminusers and listmanageduser utilities to obtain the existing credentials.
- 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 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 ckop99_ql Wdnh2vam2fdm;opitmiotu --prompt no