cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

anton_levin
Active Contributor

Hello Prashant, please check with online documentation

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

"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

Answers (0)