Skip to Content
0

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

Jan 18 at 08:03 AM

36

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bartosz Jarkowski Jan 18 at 09:04 AM
0

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!"

Share
10 |10000 characters needed characters left characters exceeded