How to reset the SYSTEM User Password in the System Database without USER Admin access

How to reset the SYSTEM User Password in the System Database.

The database administrator has a number of options to reset the password for the SYSTEM user in the system database.

Situation:

1. If you can log on as the SYSTEM user  --> Logon credentials for the SYSTEM user in the system database

2. If you cannot log on as the SYSTEM user --> 

• The system privilege USER ADMIN for a different user
• To reset the SYSTEM user password in emergency mode, you need the credentials of the operating system administrator (<sid>adm).

Context : 

1. If you can log on as the SYSTEM user.

• Change the password using SAP HANA cockpit.
• Log onto the system database, and choose User & Role Management  Manage Users.
• Log onto the system database, and execute the ALTER USER SQL statement:  

                  ALTER USER SYSTEM PASSWORD <new_password>

2. If you cannot log on as the SYSTEM user

• If the password of the SYSTEM user has been irretrievably lost, you cannot log on to the database as the SYSTEM user.
• A user with the system privilege USER ADMIN can set a new password for the SYSTEM user.
• Alternatively, you can reset the password as the operating system administrator by starting the name server in emergency mode. Follow the steps below.

Procedure:

To reset the SYSTEM user password in emergency mode:

1. Log on to the server on which the name server of the system database is running as the operating system user (that is, <sid>adm user).

2. Open a command line interface.

3. Shut down the instance by executing the following command:

/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StopSystem HDB

4. In a new session, start the name server of the system database by executing the following commands:

/usr/sap/<SID>/HDB<instance>/hdbenv.sh

/usr/sap/<SID>/HDB<instance>/exe/hdbnameserver -resetUserSystem

After some start-up notifications, the prompt resetting of user SYSTEM - new password appears, followed by additional notifications, 

Reset SYSTEM User Password (System Database)

5. After the last notification appears, enter a new password for the SYSTEM user.

You must enter a password that complies with the password policy configured for the system.

The password for the SYSTEM user of the system database is reset and the name server stops.

6. In a new session, start the instance by executing the following command:

/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StartSystem HDB

Reference URL : Link

For Education purpose only