How to unlock/reactivate the SYSTEM user on SAP HANA?

How to unlock/reactivate the SYSTEM user on SAP HANA?

Symptom:

You want to know how you can unlock/reactivate the SYSTEM user on SAP HANA.

Resolution;

•  Activate/reactivate the SYSTEM user follow the steps of "Resetting the SYSTEM User Password" in the SAP HANA Administration Guide.
• Unlock the SYSTEM user following the procedures below (if there is another user with USER ADMIN privilege):

1. Check who has the privilege "USER ADMIN" by running:

     SELECT DISTINCT object_type, privilege, grantee FROM SYS.GRANTED_PRIVILEGES where privilege = 'USER ADMIN'

2. Connect to HANA using the user, found in step 1 and run the following SQL command to unlock the SYSTEM user.

ALTER USER SYSTEM RESET CONNECT ATTEMPTS;

3. Check user SYSTEM is now available.

SELECT * FROM SYS.USERS where user_name = 'SYSTEM'

4. Now you can log on with SYSTEM user again.

 

Reference Snote: 2736167