Change Database Password For SAP Monday, October 20, 2008

Changing Password for Database Users Using BRCONNECT

As of Release 6.10, you can use BRCONNECT to change the passwords for the database users SAP, SYS, or SYSTEM.

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

You can either change the passwords with BRCONNECT interactively or by using the command line.
Interactively
1. Start BRCONNECT with the command:

brconnect [-u system/] –f chpass –u

2. Enter the new password twice for confirmation.

Note

When you change the password interactively, on some platforms you can enter the new password hidden, as long as it is no longer than eight characters.
Using the command line

Enter the following command:

brconnect [-u system/] –c –f chpass –u –p

Where:

is the password of the SYSTEM database user. You can use another user with DBA privileges.

is the database user for which the password should be changed (for example, SAP).

is the new password for the user.

Note

If you omit the -u option, then the logon occurs using SYSTEM with its default password.

0 comments:

A NOTE>>>

The articles here are based on my own experiences in using and learning BASIS . All resources related would be mentioned in every article.

Feel free to gave critics, correction, or encouragement. Any comment or question are welcomed.

Cheers,
Gagan Deep Kushal
zk.gagan@gmail.com