Password was not used for a long period message on HANA

If you are getting trouble while trying to log on a SAP system with the message “Password was not used for a long period and therefore deactivated” on a HANA database system, then you can solve it easily with the following SQL statement.

If you did not logon a SAP system with your initial password  longer that the value which assigned to parameterlogin/password_max_idle_initial”, then you cannot logon the system with message Password was not used for a long period and therefore deactivated” like shown in the below picture ;

Password was not used for a long period message on HANA

In this case, logon the HANA database via HANA studio and execute the following SQL statement ;

update SAPSR3.USR02 set PWDCHGDATE=’<CURRENT_DATE>‘, PWDLGNDATE=’<CURRENT_DATE>‘, TRDAT=’<CURRENT_DATE>‘, UFLAG=’0‘ where BNAME = ‘<USERNAME>‘ and MANDT = ‘<CLIENT>

Password was not used for a long period message on HANA

Now you can logon your SAP system with the initial password.

 

 

 

Leave a Reply


six × 4 =

Blogroll