SAP HANA - Change password SQL

Question

How do I change my password in SAP HANA via SQL.
(or other users if I am an Administrator)

I did view the HANA Dokumentation : ALTER USER Statement

So I tried ALTER USER <user_name> PASSWORD '<new_password>' with no success.

Sesquioxide

Answer 1

Use double quotes : ALTER USER <user_name> PASSWORD "<new_password>"

(Unfortunately this is not mentioned in the provided Link).

Sesquioxide

the doc mentions no quotes at all – Savdeep

The command actually is ALTER USER <user_name> PASSWORD <new_password>. The double quotes are only required for passwords with special characters. – Zurn

@LarsBr.Thx I updated Q&A. Feel free to edit the question / answer next time – Sesquioxide