How to manage password in BW on HANA ?

[sls9472]

Hi all,

         After the installation of BW on HANA, for security reason, I would like to change the password of the schema.  I remember in BW on Oracle, we could use BR Tool to change the password.  Using BR Tools, the password was changed in the Oracle database and the configuration file on the OS.   Does HANA goes through the same process and if so where is config file located, in which directory.

Thank you

[Former Member · Accepted solution]

Hello Sushil,

similar to MaxDB you have to provide the password in a secure store location. If the password of the SAP Schema User in HANA is changed, then you have to update the secure store location accordingly:

su - sidadm
hdbuserstore -u SAP<SID> set default <dbhost>:<dbport> <dbuser> <dbpassword>

The information is written into file /home/sidadm/.hdb/<hostname>/SSFS_HDB.DAT

Check the connection is working again via:

R3trans -d

Regards.

Mark

[sls9472 · Accepted solution]

Thank you Mark,

                         I am not so familiar with MAXDB, therefore couldn't relate to it.  I am doing the BW install on HANA and once completed I will try it out. 

                       Just wondering if this procedure is documented in HANA Security Guide?

Thank you again

  Sushil Singh

[Former Member · Accepted solution]

Hello Sushil,

yes, there is section 10.4 "Secure User Store" in the HANA Security Guide:

https://help.sap.com/hana/hana_sec_en.pdf

See page 53.

You can easily change the password of database user SAP<SID> via the HANA Studio.

Regards,

Mark

[former_member195731 · Accepted solution]

about:

su - sidadm

hdbuserstore -u SAP<SID> set default <dbhost>:<dbport> <dbuser> <dbpassword>

-u SAP<SID> gives problems in env with sudo

Error 91007: Impersonation not supported, use sudo on this platform.

it worked fine without -u

su - sidadm

hdbuserstore  set default <dbhost>:<dbport> <dbuser> <dbpassword>