Skip to Content

reset sap hana system password


i want to reset SYSTEM Password for Sap Hana DB
i want to know if there are any effect on running db or what per-requistes
action to avoid any db interrupt or failing.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 31, 2018 at 10:53 AM

    Hi Mohammed,

    It this is your SAP HANA database, you are the only one that would know.

    For productive systems, in fact, SAP. recommends to deactivate the SYSTEM user, see

    In other words, deactivating SYSTEM (or changing the password) has no repercussions on a running database. However, if the SYSTEM password is stored in SDA connections, for example, connecting to this database, changing the password will have an impact.

    My recommendation: try to get a clear picture of what is connecting to your HANA database and how, what has been developed, etc. Document this all clearly. Implement a secure password and privileges policy (documented as well) and, ideally, deactivate SYSTEM and use lesser privileged accounts.

    Does this answer your question?


    Denys / SAP HANA Academy

    Subscribe to our YouTube Channel
    Join us on LinkedIn
    Follow us on Twitter
    Github code samples

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 31, 2018 at 01:49 PM

    many thanks denys,
    you are right , but what about reset the sidadm user password for hana MDC server --- is there is any impact of my
    current running db systems ,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.