SAP HANA - Change password SQL

sql hana change-password

23,854

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

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

23,854

Thorsten Niehues

Working for Sybit & Peers, specializing in SAP HANA Worked as Head of IT for ContiTech North America Worked for many other companies (e.g. Bosch, T-Systems, IBM) programming in many languages (Java, Objective-C, PHP, JavaScript, etc.) and worked a lot with many databases (DB2, Oracle, MySQL, etc.) Studied computer science (Master) at HTWG Konstanz Studied computer science (Bachelor) at HFT Stuttgart Ongoing project: FindClimb an app which helps climbers to find their way to a climbing spot Technologies: iOS, Android, Google-Maps, Google-Shopping, HTML, Objective-C, Java, JS, VB, VBA, Perl, Shell, XML, XSD, Xcode, Eclipse, Linux (Ubuntu/Solaris/Suse/RedHat), OS X (10.8 Mountain Lion / 10.10 Yosemite), Windows (XP/Windows Server 2008/Vista/Windows7/Windows8/Windows10)

Updated on July 05, 2022

Comments

Thorsten Niehues almost 2 years

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.
juergen d over 6 years

the doc mentions no quotes at all
Lars Br. over 6 years

The command actually is ALTER USER <user_name> PASSWORD <new_password>. The double quotes are only required for passwords with special characters.
Thorsten Niehues over 6 years

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