Changing solidDB user passwords after installation

If you install the solidDB® database during the product installation, you must configure solidDB user and administrative user credentials. By default, the settings for the solidDB user are user name ounce and password ounce. The default database administrator user name and password are both dba.

About this task

To change the password for either of these two user accounts, follow the steps in this topic.
Important: If you change the solidDB port, you must run the appscanserverdbmgr tool to register the updated database location with the server. See Registering the AppScan Source Database with AppScan Enterprise Server for information about this tool.

Procedure

  1. At a command prompt, change directory to <install_dir>\solidDB\bin (where <install_dir> is the location of your AppScan Source installation).
  2. Issue the command solsql.exe "tcp 2315" (on Windows™) or solsql "tcp 2315" (on Linux™).
  3. When prompted for a Username, enter the currently-configured solidDB administrative username. By default, this is dba.
  4. When prompted for a Password, enter the currently-configured solidDB administrative password. By default, this is dba.
  5. Issue the command alter user <db_username> identified by <new_password>;. In this command:
    • <db_username> is the solidDB user whose password you want to change. You can change the solidDB user password or you can change the solidDB administrative user password.
    • <new_password> is the new password that you want to set for <db_username>.

    For example, to change the default administrative user password to newpassword123, issue the command alter user dba identified by newpassword123;.

  6. To complete the password change for the solidDB user, issue the command commit work; and then issue the command exit;.
  7. Optional: This step is only required if you have changed the solidDB user password. Do not complete this step for a change to the solidDB administrative user password. After changing the solidDB user password, you will need to change the password that is registered with the AppScan Source Database:
    1. Open a command prompt and change directory to <install_dir>\bin (where <install_dir> is the location of your AppScan Source installation).
    2. On Windows, issue the command OunceServer.exe -a <new_password>. On Linux, issue the command ounceserverd -a <new_password>. For both, <new_password> is the new password that was specified when changing the solidDB user password in the above steps.