Changing Passwords for Database Users with BRCONNECT

Use

You can use BRCONNECT to change the passwords for the database users SAP<SCHEMAID> or SYSTEM.

By using BRCONNECT, you will have the password for SAP<SCHEMAID> encrypted before storing it in the database.

Procedure

Use one of the following methods to change the passwords with BRCONNECT:

Changing the Password with BRCONNECT Interactively

  1. Start BRCONNECT with the command:

    brconnect [-u system/<system_password>] -f chpass -o <user_name>

  2. Enter the new password twice for confirmation.

Changing the Password by Using the Command Line

Enter the following command:

brconnect [-u system/<system_password>] -c -f chpass -o <user_name> -p <new_password>

Where:

  • <system_password> is the password of the SYSTEM database user. You can use another user with DBA privileges.

  • <user_name> is the database user for which the password should be changed (for example, SAP<SCHEMAID>).

  • <new_password> is the new password for the user.