When a user logins to the HANA system, the following steps are performed −
The system authenticates the user using the configured mechanism.
Example − When User name/password authentication is being enforced, the provided user name and password are verified.
The system verifies that the user's account is within its validity period.
In the system view USERS, the columns VALID_FROM and VALID_UNTIL must contain effective values for the user in question.
However, this is an optional parameter that a user administrator can set during user provisioning.
The next step is system verifies that the user's account is active.
This can be performed by checking the value in the system view “USERS”, the column IS_DEACTIVATED must contain the value FALSE for the user in question.
A user account may be deactivated explicitly by a system administrator or by the system.
Example − due to too many invalid logon attempts.
When the above checks are successful, it allows users to login to SAP HANA system.