cancel
Showing results for 
Search instead for 
Did you mean: 

Need details of table in SAP HANA database were user password is saved

former_member191388
Active Participant
0 Kudos

Hi Experts,

I want to provide custom application for the users to reset their password in SAP HANA.

So, therefore need the details of the table in SAP HANA database were user password is saved.

Thanks & regards

Arun

Accepted Solutions (0)

Answers (1)

Answers (1)

BJarkowski
Active Contributor
0 Kudos

Even if you find the place where the password is stored, most probably you won't be able to do anything with it. All passwords are encrypted, so to change the password you'd have to use the same encryption mechanism to change the password.

So, why not using a HANA statement to change the password?

ALTER USER <user> PASSWORD <new password>

for example:

ALTER USER MYUSER PASSWORD "NEWPASS123!"