Register Login

HANA Disable Password Lifetime using SQL Statement for Technical Users

Updated May 18, 2018

Your application uses a technical user to perform database queries as required by the application.

For the user, you encounter the following error/warning messages "user's password WILL EXPIRE within few days: expire time ..."

The standard password policy specifies that the password of a user has only a limited life time and needs to be changed at the end of this period. The password of the technical user is only known to the application, as the technical user is not intended for interactive use and manual login to the database.

Proceed as follows:

  • Use SAP HANA Studio and open an SQL editor using a user with the USER ADMIN system privilege (e.g. SYSTEM) to connect to your instance
  • Execute the following SQL statement:


ALTER USER <technical-user-name> DISABLE PASSWORD LIFETIME


×