SAP HANA reset the SYSTEM User Password of a Tenant Database

 

If the password of the SYSTEM user in a tenant database is forgot or lost , you as the system administrator can reset it from the system database.

Steps to change the Password:

Stop the tenant database, for example by executing the following statement:

ALTER SYSTEM STOP DATABASE <database_name>

ex: ALTER SYSTEM STOP DATABASE HDB

Create a new password for the SYSTEM user by executing the following statement:

ALTER DATABASE <database_name> SYSTEM USER PASSWORD <new_password>

ex : ALTER DATABASE HDB SYSTEM USER PASSWORD Admin#123

Note: 

The password for the SYSTEM user is reset and the tenant database is started.