Changing Database User Passwords with BRCONNECT

Use

You can use BRCONNECT to change the password of database users, such as SAPR3 or SAP<SAPSID>.

Do not leave the passwords for the database user set to the default values.

Procedure

...

For more information, see -f chpass.

Result

BRCONNECT stores the new password as follows:

User

Table

Encryption (from Release 4.5B)

SAPR3

"OPS$<ORACLE_SID>ADM".SAPUSER

Stored as SAPR3-CRYPT

SAP<SAPSID>

"OPS$<SAPSID>ADM".SAPUSER

Stored as SAP<SAPSID>-CRYPT

In the case of the SAP<SAPSID> user, <SAPSID> refers to the SAP System ID. For example, if the SAP System ID is C11, the SAP<SAPSID> user is SAPC11, stored in the table OPS$C11ADM.SAPUSER. The first character of <SAPSID> must be a letter and there is no distinction between uppercase and lowercase.

Database users other than SAPR3 and SAP<SAPSID> are not stored in SAPUSERdatabase tables.