Specifying a Database Admin Username and Password

Several maintain options require a database administrator username and password (<db-admin>). For security reasons, you cannot enter a database administrator password on the command line when invoking a maintain command. You can only provide a password when prompted by maintain, or through the encrypted DB_PASS entry in <ac-install>/bin/acserver.cnf. Here are the rules for providing this information to a maintain command:

  • If you specify a value for <db-admin> when starting the maintain command, maintain will prompt you to enter the database administrator password.

  • If you do not specify a value for <db-admin> when starting the maintain command, maintain will attempt to connect using the DB_USER and the encrypted DB_PASS values specified in
    <ac-install>/bin/acserver.cnf. In the case of standard installations, the command will fail since, for security reasons, the database role specified by DB_USER typically does not (and should not) have database administrative privileges. You will then have to specify a value for <db-admin> on the command line, and be prompted for the password.

  • If you try to specify a value for the database administrator password when starting the maintain command on the command line, maintain will display an error message.