How to unlock a locked SAP HANA user?

HANA Studio offers a secure  storage to store the user credentials and use those to connect with HANA database. If you change the user credentials, you must remember to update those in HANA studio as well.

If the studio still uses the old logon data even after you changed the password, you may see the user locked due to  multiple failed logon attempts.

Unlock locked HANA users

To check if user is deactivated or how many invalid logons s/he has use the following SQL:
SELECT NAME, USER_DEACTIVATED, INVALID_CONNECT_ATTEMPTS FROM "SYS"."P_PRINCIPALS_" WHERE NAME='<username>'

If the user was locked/deactivated for other reasons (e.g. directly by a user admin), you may need to reset the password:
alter user <username> password <password>;

Update password in HANA studio

To reset the number of failed attempts recorded, you can use the following SQL:
alter user <username> DROP CONNECT ATTEMPTS;

Comments

Popular posts from this blog

OS/DB Migration - CMD. STR, TOC, EXT, R3load, DDLDBS.TPL and more

Fixing Inconsistent Table - Table activation fails due to inconsistency between DD and DB

301 Redirect Using SAP Web Dispatcher