Skip to Content
avatar image
Former Member

HANA Locked Login scenario

This would be an extremely unusual case but  I can't find additional documentation on it.  If
you have set the Lock For parameter to indefinitely and I have locked down the
SYSTEM user,  is it possible if the system is hacked or  manually to lock
all the logins?  If so what is the correct solution resolve the issue.

This is possible in other DBMS and there is  usually a
backdoor if all the logins get locked.   I understand that SYSTEM doesn’t
participate in max failed logins but  I believe it’s a best practice to
lock SYSTEM manually once the DBA logins are created.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 01, 2014 at 01:03 AM

    Hey Cristy

    Ok, so I understand the scenario like this:

    • SYSTEM user had been locked as recommended
    • all other users have been locked (however that might have happened) and won't be unlocked automatically

    How to gain DBA access again to unlock the users?

    Unfortunately I have to system to try this out right away, but I would go on with the method @Richard Bremer described in Reactivating the SYSTEM user when no User with USER ADMIN is Available.

    Should be a 100% match to your scenario.

    BTW, tagging in SCN can be done via the "at" sign plus the name, e.g. Former Member is produced by @Cristy_Russel .

    Cheers, Lars

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Lars, thank you very much. I will try and get my hands on a test system and try option one Richard's post.