Changing Database User Passwords with BRCONNECT
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.
For more information, see -f chpass.
BRCONNECT stores the new password as follows:
User |
Table |
Encryption |
|---|---|---|
|
|
Stored as |
|
|
Stored as |
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.