SAP HANA - Change password SQL

sql hana change-password
Thorsten Niehues picture Thorsten Niehues · Aug 7, 2017 · Viewed 17.5k times · Source

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.

Answer

Thorsten Niehues picture Thorsten Niehues · Aug 7, 2017

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

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

Related questions

HANA list / show tables SQL Command

How to show / list all tables in SAP HANA via SQL?

Read More
How to convert a string to date in SAP HANA SQL select statement?

How do i convert a string '20120215' to a date format YYYY-MM-DD (2012-02-15) in a SQL SELECT statement? I am using SAP HANA SQL.

Read More
Combine LIKE and CONTAINS in SAP HANA

Consider the following entries in my table: red apple yellow apple apple green red aple appel yellow Several people have populated this table using a non-consistend notation (the color before or after 'apple'), also entering some spelling errors. Now I …

Read More