Skip to Content
-2

reset sap hana system password

dear,

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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 31 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?

    Regards,

    Denys / SAP HANA Academy

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31 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 comment
    10|10000 characters needed characters exceeded