Online Tutorials & Training Materials | STechies.com
Register Login

HANA Disable Password Lifetime using SQL Statement for Technical Users

|| || 0

HANA Disable Password Lifetime using SQL Statement for Technical Users
Stechies

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


Related Articles

0.0131 seconds.