hdbuserstore in hana | How to set hdbuserstore Keys

The hdbuserstore is also called as secure user store is a tool installed with the SAP HANA client

The secure user store allows you to store SAP HANA connection information, including user passwords, securely on clients. In this way, client applications can connect to SAP HANA without the user having to enter host name or logon credentials.

The secure user store is installed with the SAP HANA client package. After you install the SAP HANA client, the hdbuserstore program is located in one for the following directories:
/usr/sap/hdbclient (Linux/UNIX)

To Check list of hdbuserstore  keys

hdbuserstore list – displays list of keys .

hdbuserstore list 
DATA FILE : /usr/sap/IGB/home/.hdb/vsaxyz/SSFS_HDB.DAT
KEY FILE : /usr/sap/IGB/home/.hdb/vsa1xyz/SSFS_HDB.KEY
KEY BKPMON
ENV : lddbaxyz:30015
USER: bkpmon
KEY SRTAKEOVER
ENV : lddbaxyz:30015
USER: system
KEY W
ENV : lddbaxyz:30015
USER: system

To check  key information using hdbuserstore

Give hdbuserstore list <Keyname>

hdbuserstore list BKPMON
KEY BKPMON
ENV : lddbaxyz:30015
USER: bkpmon

To Set hdbuserstore key in Single Node HANA System

hdbuserstore set <KEY> <hostname:port> <User> '<Password>'

To Set hdbuserstore key for Multi Node HANA system (scale-out)
hdbuserstore set  -i <KEY> <hostname1:port,hostname2:port ... hostnamen:port> <User> '<Password>'

Parameter -i allows to give the password in a secure way

Set hdbuserstore key for Tenant Database

hdbuserstore SET DB1 <hostname1:port,hostname2:port ... hostnamen:port> <user> <password>
hdbuserstore SET DB1 <hostname1:port,hostname2:port ... hostnamen:port> <user> <password>

Where DB1 and DB2 are your tenant databases.

To delete hdbuserstore key
hdbuserstore DELETE <Key>

 

Leave a Reply