How to reset User password from HANA Database

Statement 'SELECT * FROM SAPDGT.USR02 WHERE BNAME = 'DDIC' AND MANDT = '310'' 

Statement 'update USR02 set uflag=0 where mandt='310' and bname='DDIC'' 

update USR02 set PASSCODE = 'CELAzure1234#' where mandt='310' and bname='DDIC'

Export and Import Certificates in SAP SYSTEM before and after Refresh

 to Export and Import Certificates in SAP SYSTEM before and after Refresh:

Procedure: follow the steps specified in the blog:

https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-members/restore-pse-in-strust/ba-p/13274842