Skip To Content

Alter relational data store account passwords

ArcGIS Data Store randomly generates user names 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 set your own passwords, use the listadminusers and listmanageduser utilities to get the names of the accounts that perform administrator tasks in the data store and the account that owns the data in the data store, respectively. Then run the changepassword utility to set new passwords for the accounts.

In the following example, the passwords for the administrator, replica owner, and geodatabase administrator are obtained and changed:

./listadminusers

Admin users for ArcGIS Data store ds_abcd1234
=================================================
Database Admin User.... adm_11zyx / tT30!bYk22jF
Database Repl User..... dsrepuser / uWn/MV0678h4
GDB Admin User......... sde / iO=Qst751*pb

./changepassword adm_32ret SIcr.Or0

You are going to change the password for user adm_32ret.
Do you want to continue (Yes or No)? Yes

./changepassword dsrepuser Copy$line

You are going to change the password for user dsrepuser.
Do you want to continue (Yes or No)? Yes

./changepassword sde Tbco*tgdb

You are going to change the password for user Tbco*tgdb.
Do you want to continue (Yes or No)? Yes

The next example obtains and changes the password for the managed user. The managed user publishes hosted feature layers.

/listmanageduser

Managed users for ArcGIS Data store ds_abcd1234
================================================
UserName     Password             Database
gwi_n2Te0    4cXddhZhve=Y         db_qv5e1


/changepassword gwi_n2Te0 Phfl4mp!

You are going to change the password for user gwi_n2Te0.
Do you want to continue (Yes or No)? Yes

Tip:

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

changepassword gwi_n2Te0 Phfl4mp! --prompt no