user password reset for user re-use in hdbuserstore list

case studies:

1. If the HDB user password is restarted by the user, with out updating the password in hdbuserstore list. then the following steps need to perform.
2. If the user is locked, due to wrong password in hdbuserstore list.
3. Generally hdbuserstore key allows 6 attempts of wrong password, after that user will locked.
4. hdbuserstore list keys basically use for scripts.

steps:

alter user <user name> reset connect attempts.

alter user <user name> active user now

To change password:

alter user <user nsame> password <password>

SAP HANA notes 29: How to reset system user password in SAP HANA environment

How to reset system user password in SAP HANA environment

Procedure:

step1: log in the putty session with <SID>ADM.

step2:  navigate to: usr/sap/<SID>/HBDXX/exe

step3: stop SAP Application - in case the system installation in non distributive using the cmd as                   below:

           sapcontrol -nr <XX>   -host <HOSTNAME>   -function Stop

           
                                          &

                                  HDB stop  

wait for the process until the SAP application turn off.

step4: Now open another putty session and login with <SID>adm user.

step5:To start the name server of the system DB.

           usr/sap/<SID>/HDBXX> ./hdbenv.sh

step6: Navigate to /usr/sap/<SID>/HBDXX/exe >hdbnameserver -resetusersystem

step7: after completing the step 6 execution.

           provide new password for system user.

step8: start the DB - HDB start

           start the Application -    sapcontrol  -nr <XX> -host <Hostname> -function Start

step9: Hurrah!!!

login with new system user password  in HANA studio.

                                                   ---Thanks for visiting my Blog---