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.
Asked
Active
Viewed 3.2k times
4
Thorsten Niehues
- 13,712
- 22
- 78
- 113
1 Answers
10
Use double quotes : ALTER USER <user_name> PASSWORD "<new_password>"
(Unfortunately this is not mentioned in the provided Link).
Thorsten Niehues
- 13,712
- 22
- 78
- 113
-
the doc mentions no quotes at all – juergen d Aug 07 '17 at 11:08
-
2The command actually is ALTER USER
PASSWORD – Lars Br. Aug 07 '17 at 21:13. The double quotes are only required for passwords with special characters. -
@LarsBr.Thx I updated Q&A. Feel free to edit the question / answer next time – Thorsten Niehues Aug 08 '17 at 06:23