SAP HANA 2.0 重置system 管理员密码

发布时间 2023-05-23 14:53:18作者: 踏雪无痕2017
1.重置SYSTEM DB
su - hdbadm
HDB stop
-- open  a another  ssh session
su - hdbadm
hdbenv.ssh
hdbnameserver -resetUserSystem
-- go back to original ssh session
HDB start

2.重置Tenant DB
--login system db
ALTER SYSTEM STOP DATABASE TEST
ALTER DATABASE TEST SYSTEM USER PASSWORD "new_password"

--login hana  studio change system user password again