-f chpass (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

-f chpass

This BRCONNECT function changes the database user password.

Recommendation

We strongly recommend you to use this BRCONNECT function rather than the equivalent SAPDBA one, sapdba -alter_user. The reason is that we will in future no longer develop the SAPDBA functions, whereas BRCONNECT functions will always be fully up-to-date.

Function options:

-o|-owner: Defines for which database owner (that is, user) the password is to be changed.

Input syntax: -o <owner1>[,<owner2>,...]

Default value: SAPR3/SAP<SID> in a standard SAP database or all SAP owners in a multi-schema database

-p|-password: Defines the password for the SAP database owner (that is, user)

Input syntax: -p <password>

Default value: interactive entry of the password