Reset SYSTEM User's Password

[Former Member]

Can anyone tell me how to reset  SYSTEM User's Password in HANA?

Thanks,

RV

[shashisingh · Accepted solution]

Hi Ruby

You can follow these steps.

Log on to the server on which the of the SAP HANA master index server 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 HDB4.

Start the name server by executing the following commands:○/usr/sap/<SID>/HDB<instance>/hdbenv.sh○/usr/sap/<SID>/HDB<instance>/exe/hdbnameserver5.

Start an index server in console mode by executing the following commands:○/usr/sap/<SID>/HDB<instance>/hdbenv.sh○/usr/sap/<SID>/HDB<instance>/exe/hdbindexserver -console

You see the output of a starting index server. When the service has started, you have a console to the SAP HANA instance where you are logged on as the SYSTEM user.6.

You can reset the SYSTEM user's password and store the new password in a secure location with the following SQL command:ALTER USER SYSTEM password <new password>

Thanks,

Shashi

[vivekbhoj]

Hi Ruby,

You need <sid>adm User access to reset SYSTEM user password.

Just follow the below document to reset HANA SYSTEM user password:

http://scn.sap.com/docs/DOC-33097

Regards,

Vivek