How to change SAP HANA password ?
Error : "SAP DBTech JDBC: [414]: As per your password policy, current user is forced to change DB password." error message is shown.
Cause :
The standard password policy specifies that a new user must change their password upon logging into HANA for the first time.
The standard password policy specifies that a new user must change their password upon logging into HANA for the first time.
Solution:
Change SAP HANA DB password or Update Password policy.
Execute in HANA DB :
hdbsql =>
ALTER USER <user> DISABLE PASSWORD LIFETIME
CONNECT <user> PASSWORD "<Password>"
Passwords containing special characters other than an underscore must be enclosed in double quotes (").
SAP Notes :