Resetting SYSTEM password in SAP Cloud MDC HANA Tenant

[abhijeetgc]

We have some tenants in HANA MDC in SAP CP Neo the SYSTEM user password is not working. Since we do not have OS level access how do we solve this issue? There are solutions where if you have OS level access then you can reset it for HANA on premise. What do we do for HANA on Cloud?

[abdel_dadouche · Accepted solution]

Hi abhijeet.gc

As robert.russell2, you not let your SYSTEM user unattended! Everyone knows it exists. So anyone finding your instance IP, could potentially try to connect and ultimately lock it.

I usually recommend people to create a "copy" of the system user with a distinct name so that no one can find it.

By default, the lock will remain for 1440 minutes(24h) unless you permanently locked it.

Then your only option is to contact support which will unlock it for you at the cost of a "downtime" (the instance will be shutdown and restarted).

Hope this helps

[Robert_Russell]

Your not supposed to use the SYSTEM user.

Ref SAP note

2458474 - Issues with SYSTEM, BKPMON, CERTADM, and PSADBA users on SAP HANA Cloud Platform

https://launchpad.support.sap.com/#/notes/2458474

And from the help

Your database user is assigned a set of permissions for administering the SAP HANA database system, which includes HCP_PUBLIC, and HCP_SYSTEM. The HCP_SYSTEM role contains, for example, privileges that allow you to create database users and grant additional roles to your own and other database users.