Skip to Content
avatar image
Former Member

HANA user locked with too many invalid connect attempts

Hi,

I met one issue about user been locked by too many invalid connect attempts. After I used SYSTEM user to reactive this user and change the password in HANA studio, just few minutes later, the user would be locked with same reason even I did not do any operation on system. I totally got lost how it could happened. Could anyone please to help me on that ?

Thanks in ton.

Regards,

Andy Zhang

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    I checked in my HANA studio. When I scan the object inside this user, after I run code:

    select * from sys.INVALID_CONNECT_ATTEMPTS where user_name= <user_name>

    It will generate two more rows about invalid connect attempts.

    For the other user in the system, no such issue there. Also this issue just comes in recent days. I have totally no idea how to solve it since the user is little important in our system.

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Feb 02, 2017 at 05:12 PM

    Hi Andy,

    I think you have used your ID explicitly somewhere else also, may be in some connection, or some one else's machine. You need to change the password there also. You can also ask security to put a trace on your USER to resolve this issue.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mrityunjay,

      Thank you very much for your answer, I found there is one place who used the old password to trigger this account. Now I fixed the issue.

      regards,

      Andy Zhang