Skip to Content

HANA user locked with too many invalid connect attempts

Feb 02, 2017 at 06:47 AM


avatar image


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.


Andy Zhang

10 |10000 characters needed characters left characters exceeded

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.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mrityunjay Pandey 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.


Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.


Andy Zhang