MENU

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Saturday, April 30, 2016

how to set user key in hana

you can store user password in the form of key in HANA database by using hdbuserstore tool as below.

How to check Key Information -

vsa21000:HDB:ABCadm /usr/sap/ABC/HDB00 51> hdbuserstore list

DATA FILE       : /usr/sap/ABC/home/.hdb/vsa21000/SSFS_HDB.DAT
KEY FILE        : /usr/sap/ABC/home/.hdb/vsa21000/SSFS_HDB.KEY

KEY DEFSID
  ENV : vadbSID:30255
  USER: HANADBXYZ
KEY KEY01
  ENV : vadbSID:30255
  USER: system
KEY SID
  ENV : localhost:30255
  USER: system

Store password in KEY BKP with following command:

hdbuserstore -v SET (key_name) vadb(sid):30255 (user_name) (password)

Example -

hdbuserstore -v SET bkp vadbabc:30255 bkpkey abc123

vuv1000:HDB:sidadm xyz/usr/sap/SID/HDB00 51> hdbuserstore list

DATA FILE       : xyz/usr/sap/SID/home/.hdb/vuv1000/XYFS_HDB.DAT
KEY FILE        : xyz/usr/sap/SID/home/.hdb/vuv1000/XYFS_HDB.KEY

KEY BKP
  ENV : vadbsid:30255
  USER: bkp
KEY DEFSID
  ENV : vadbsid:30255
  USER: HANADBXY
KEY KEY01
  ENV : vadbABC:30255
  USER: system
KEY ABC
  ENV : localhost:30255
  USER: system

3 comments:

Unknown said...

Very useful info shared by your side...
SAP SD Online Training | SAP FSCM Online Training in Hyderabad

Anonymous said...

Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog.
SAP MM

Cranesoft said...

this is vary valuable information you shared about sap hana and now these time sap hana and sap fico are the best in demand according to companies sap training institutes in bangalore and sap training institutes in bangalore