SAPR3 user expired.

[Former Member]

Hi All,

In our system database user SAPR3 is expired and when I am trying to unlock this user and in the process it is asking me the old password which I am not aware of.

Please some body tell me how to reset the password.

Regards,

Reddy.

[Former Member]

Hi Shekar,

Even if you change the password at DB level ,you should update yhe new pasword in SAPUSER table.

So It's better to change the SAPR3 password with help of BRTOOLS so that the new passowrd will be updated in SAPUSER table and OPS$ mechanisam will work with out any issues.

Regards,

Srinivas Chapa.

[Former Member]

Hi,

See the below link..Hope this will helpful you..

http://help.sap.com/saphelp_470/helpdata/en/0d/d2f8a54a0c11d182b80000e829fbfe/content.htm

Regards

[Former Member]

Hi Shekhar,

Please try to change password at oracle level

ALTER USER SAPSR3 IDENTIFIED BY SAP;

Regards

Pranay Agarwal

[Former Member]

Hi,

I would prefer chaging using brtools.We have option to change as suggested above presuming db is oracle.

[Former Member]

Just to share, if anyone search for this error.

1. ALTER USER SAPSR3 ACCOUNT UNLOCK; /to unlock

2. ALTER USER SAPSR3 IDENTIFIED BY SAP; /to change password at oracle level

3. To allow continued logon of the R/3 work processes using the OPS$ mechanism, you must also change the password in the SAPUSER table. The simplest way of making a consistent change in the Oracle dictionary and in the

SAPSR3 table is to use the " -f chpass" option of brconnect, for example:

brconnect -f chpass -o sapsr3 -p <new_password>

Thanks

[JPReyes]

You can reset the user password directly at DB level using command,

alter user SAPR3 idenfied by sap;

sap been the default password.

Regards

Juan

[Former Member]

hi friend

Check attached link

try to login DDIC or some other user and you can unlock the user use tcode su01

regards

krshna