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
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:
Very useful info shared by your side...
SAP SD Online Training | SAP FSCM Online Training in Hyderabad
Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog.
SAP MM
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
Post a Comment