Tuesday 8 August 2017

How to set user key in SAP HANA Database



We can store user password in the form of key in SAP HANA database by using hdbuserstore tool

Check Key Information in SAP HANA :

Hostname:/usr/sap/<SID>/HDB00>hdbuserstore list

DATA FILE     /usr/sap/home/.hdb/hostname/SSFS_HDB.DAT

KEY FILE      /usr/sap/home/.hdb/hostname/SSFS_HDB.KEY

KEY DEFSID

ENV      :  XYZSID:30255
USER    : HANADBXYZ

KEY KEY02

ENV       :  XYZSID:30255
USER      : system

KEY SID

ENV    : localhost:30255
USER  : system

Store Password in Key File/

use the below command to store user and password in KEY File,

hdbuserstore -v SET(KEY _name) XYZDB(SID>):30255 (user_name),(Password)

Ex:

hdbuserstore  -v SET bkp XYZHDB:30255 root,PASSWORD

Hostname:/usr/sap/<SID>/HDB00/>hdbuserstore list

DATAFILE      :  XYZ/usr/sap/SID/home/.hdb/HDB000/XYZ_HDB.DAT

KEY FILE       :  XYZ/usr/sap/SID/home/.hdb/HDB000/XYZ_HDB.KEY

KEY BKP

ENV      :  XYZSID:30255
USER    : bkp

KEY DEFSID

ENV      :   XYZSID:30255
USER    :  HANADBXYZ

KEY KEY02

ENV      :    XYZSID:30255
USER    :   system

KEY XYZ

ENV       : localhost :2017
USER      : SYSTEM









EmoticonEmoticon

Note: only a member of this blog may post a comment.