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