Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SAP HANA - Change password SQL

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.

like image 699
Thorsten Niehues Avatar asked Mar 09 '23 09:03

Thorsten Niehues


1 Answers

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

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

like image 105
Thorsten Niehues Avatar answered Mar 15 '23 12:03

Thorsten Niehues