Basically, the SYSTEM database and TENANT database(s) have their own SYSTEM user maintained. Depending on your requirements, you may reset them as below,
Reset SYSTEM User in TENANT Database
Two scenario to be cover at this area and the first scenario is you can access the TENANT database with user that having USER ADMIN system privilege. For this case, execute below command. We are going to use SAP HANA Studio for this whole activities.
#1. Stop the Tenant Database.
ALTER SYSTEM STOP DATABASE [TENANT-DB-NAME]
#2. Reset SYSTEM user password.
ALTER USER SYSTEM PASSWORD [NEW-PASSWORD]
#3. Start the Tenant Database.
ALTER SYSTEM START DATABASE [TENANT-DB-NAME]
Alternatively, login to the TENANT database with other user ID which having the USER ADMIN privilege. Go to Security > Users. Look and double click on the SYSTEM user. From here, change the password and save the change. You can leave the option of Force password change on next logon to Yes if you want to change the SYSTEM password again.
Reset SYSTEM User in SYSTEM Database
If you have the SYSTEM user password but you want to change the password, use below command or using the user editor in SAP HANA Studio.
ALTER USER SYSTEM PASSWORD [NEW-PASSWORD]
But, if you have lost it, then you can follow below steps,
1. Login to the operating system level via SIDADM.
2. Open the command line interface and execute below command to shutdown the HANA database.
usr/sap/[SID]/HDB[xx]/exe/sapcontrol -nr [xx] -function StopSystem HDB
3. Start a new command line interface session and execute below commands.
/usr/sap/[SID]/HDB[xx]/hdbenv.sh
/usr/sap/[SID]/HDB[xx]/exe/hdbnameserver -resetUserSystem
4. Wait for a while and you will be prompt to enter a new password for SYSTEM user. Enter the new password.
5. Open a new session again and execute below command to start the HANA database.
/usr/sap/[SID]/HDB[xx]/exe/sapcontrol -nr [xx] -function StartSystem HDB
Note
- xx = Instance Number.
- SID = System ID.
- SAP Help reference.
