How to Permanently Disable User Password in SAP HANA Database

Launch the SAP HANA studio and open the SQL editor with USER ADMIN system privilege (e.g. SYSTEM) user to connect to your instance.

Execute the following SQL statement:

alter [USER-NAME] disable PASSWORD LIFETIME

To check if the password lifetime is enable or disable, use below command and refer to field PASSWORD_CHANGE_TIME. If the value is set to NULL (or ?), it means the password life for the user is disabled.

select * from USERS

Reference

• 1702224 – Disable password lifetime for technical users
• 2278879 – How to check result of ‘DISABLE PASSWORD LIFETIME’