Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 18 at 09:04 AM

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

    Add comment
    10|10000 characters needed characters exceeded