Skip to Content
avatar image
Former Member

How to set Hana DB User's password to never expires?

We have a Java application in HCP.

We are using Hana DB. The DataSourceBinding configuration requires us to key-in the Database UserName and Password.

When the password expires, application starts throwing error.

To avoid this, can we set the database user's password to never expire?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 09, 2016 at 03:34 PM

    Hello Prashant, please check with online documentation

    https://help.sap.com/saphelp_hanaplatform/helpdata/en/61/662e3032ad4f8dbdb5063a21a7d706/content.htm#id_k4d_wkl_45

    "A user administrator can exclude users from this password check with the following SQL statement: ALTER USER <user_name> DISABLE PASSWORD LIFETIME. However, this is recommended only for technical users only, not database users that correspond to real people. A user administrator can re-enable the password lifetime check for a user with the following SQL statement: ALTER USER <user_name> ENABLE PASSWORD LIFETIME."

    Regards,

    Anton

    P.S. Please, also get familiar with Rules of Engagements http://www.sap.com/community/about/rules-of-engagement.html -> #3 Search before you post

    Add comment
    10|10000 characters needed characters exceeded