Show TOC

Changing Database User Passwords with BRCONNECTLocate this document in the navigation structure

Use

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

Caution

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

SAPR3

"OPS$<SAPSID>ADM".SAPUSER

Stored as SAPR3-CRYPT

SAP<SCHEMA_ID>

"OPS$<SAPSID>ADM".SAPUSER

Stored as SAP<SCHEMA_ID>-CRYPT

Note

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

Database users other than SAPR3 and SAP<SCHEMA_ID> are not stored in SAPUSER database tables.