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>