9/04/2012

SAP 4.6 password change from SQL

Following next example you can change users password in another client (mandt) if you forgot it or else.  Valid for  SAP 4.6 and above.


sqlplus '/as sysdba'
 
SQL> select bcode, passcode from sapsr3.usr02 where mandt='032' and
bname = 'BOBBY';

BCODE            PASSCODE
---------------- ----------------------------------------
5CC500F30C186926 FD08F241B815CAB5A95945272BB399D5FA0AFB0F

SQL> update sapsr3.usr02 set bcode='5CC500F30C186926',
passcode='FD08F241B815CAB5A95945272BB399D5FA0AFB0F' where mandt='033'
and bname='BOBBY';

No comments:

Post a Comment

Popular Posts