How to unlock a sap hana user
A user contacted you as he cannot connect to a database. You checked the 
user status that is currently in trouble in order to decide which action to process next.
At the user level, he is locked. At the administrator level his connection is blocked for a specific reason.
There are few reasons which are explained further down. Each reason will require a different procedure in order to release the locking mechanism.
Analyzing and Unlocking a sap hana user
A sap hana user can be locked in various situations. The most common event is the amount of failed connections in a row which are limited to 5 by default.
Reasons why a sap hana user might be locked
Reason 1.
The User has been locked manually by an administrator.
You want to reactivate the user.
Activate user
Questions to ask:
- Why was he deactivated?
- Is it a temporary technical user?
- Was the user locked as part of a security protocol?
- Is it a personal user?
- Has the account been locked due to unauthorized access?
Reason 2.
The user connection has expired.
Update the user connection validity datePlease Note: A time limit on a connection is not set by default. It has been limited by an administrator.
Questions to ask:
If the connection validity date is prolonged or removed and the user is still unable to connect.
1/ Is the user locked or deactivated as well?
2/ Is there too many user connection attempts also?
3/ Has the password expired
Reason 3.
User is locked due to password expiration date.
Questions to ask:
1/ Is it a standard user
Update password with change password on next connection2/ Is it a temporary technical user :
Update password with new password3/ Is it a batch technical user :
Update password with previous passwordReason 4.
User cannot connect due too many connection attempts.
Reset user connection attemptsNote: If the update does not give any result, check also
1/ Is the user locked or deactivated?
Troubleshooting connection errors