9/04/2012

SAP users password without expiration

How to skip password change in SAP?

To skip password change to the user when it is time to change the password.

Go to sqlplus as sysdba or sapsr3 user, then open 
sapsr3.usr02  table.


SQL> select PWDCHGDATE from sapsr3.usr02 where mandt='001' and bname='USER';

PWDCHGDATE
------------------------
20071214

Changing date to 9999.12.31

SQL> update sapsr3.usr02 set PWDCHGDATE='99991231'where mandt='001' and bname='USER';

1 row updated.

SQL> select PWDCHGDATE from sapsr3.usr02 where mandt='001' and bname='DDIC';

PWDCHGDATE
------------------------
99991231

SQL> commit work;

Commit complete.

Enjoy!! Your SAP password will never expire. But remember for all subsequent risks.

No comments:

Post a Comment

Popular Posts