how to reset password of SAP users from the oracle database

[Former Member]

Hi experts,

Is there any way to reset the password of the SAP users from database??

Vineet

[Former Member · Accepted solution]

1. sqlplus "/as sysdba"

2. UPDATE SAP<SID>.USR02 SET UFLAG = 0 WHERE MANDT = "<client number" AND

BNAME = "<your user ID>"

UFLAG - means your lock mode <..0,64,128...>

MANDT - you client

BNAME - your user name

Regards

Kasi

[Former Member · Accepted solution]

Hi Kasi,

Thnx for prompt rply.

Can you please tell me how can I determine the lock mode so as to set in UFLAG.

Is this process of reseting passoword is applicable for SAP standard user or any user.

[Former Member · Accepted solution]

yes Vineet,

It is the same way as said by Kasi just that I dont think that you need Lock mode in the sql statement.

Also you can lock/unlock or reser password of any user not only SAP standard user through SQLPLUS

Rohit

[Former Member · Accepted solution]

Hello Vineet

you can check the value of lock modes via select statement

SQL> select UFLAG from SAPR3.USR02 where MANDT=000 and BNAME='DDIC';

UFLAG

-

---

0

SQL>

SAP comes with various lock codes:

0 Not Locked

32 Locked Globally By Administrator

64 Locked Locally By Administrator

128 Locked Due To Incorrect Logons

thanks

Bhudev

[Former Member]

Hello Vineet

You can just unlock the SAP users from sqlplus as Kasi mentioned here the update query but not possible to reset the password for SAP users through db.

thanks

Bhudev

[Former Member]

Hi

Stranage never heard this you can reset it via SU01 right. then why you want to reset it via database level any particular reason?

You can delete sap* from database which recreates the sap* and can login with pass level when you are unable to login to system

Regards

Uday

[Former Member]

Yes Vineet

you can do it by logging on to SQL plus

Rohit

[Former Member]

Thnx Rohit,

Is it in the same way from SQL PLUS as mentioned below by Kasi.