Skip to Content
0

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

Dec 09, 2016 at 12:23 PM

5.9k

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Anton Levin
Dec 09, 2016 at 03:34 PM
2

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

Share
10 |10000 characters needed characters left characters exceeded