User hana is locked

[former_member201820]

Hi Guys,

We are a project of load for ECC, the tool used is Data Services(4.1-SP2) on Hana.

Anybody are tried make login, but with other password... like this occurs locking the user.

I tried commands into sql:

SELECT * FROM sys.INVALID_CONNECT_ATTEMPTS WHERE user_name='USER'

But so it show the last locks.

There is some Granted Role/System Privileges to add at user does not get locked?

[former_member220937 · Accepted solution]

Hi

You can increase the number of failed login attempts by opening the password policy

this can be bone by double clicking on the security and selecting the password policy

All questions related to password issues are answered in the security guide section

Reference7.2.1 Password Policy Configuration Options

you can find the guide here

http://help.sap.com/hana/SAP_HANA_Security_Guide_en.pdf

Hope this helps you

BR

Dermot

[former_member201820 · Accepted solution]

Hi Dermot!

Now users do not become blocked, but I think Hana should have more information in user tables to store this kind of situation.

BR

Tobias

[rindia · Accepted solution]

Hi Tobias,

How you resolved your problem?

Have you increased

Number of Allowed Failed Logon Attempts (maximum_invalid_connect_attempts) to a higher value?

What you added role/privilege to user so that he is not getting blocked?

Regards

Raj

[former_member201820 · Accepted solution]

Hi Salla,

So...

With command below, i see the number the erros access

SELECT * FROM sys.INVALID_CONNECT_ATTEMPTS WHERE user_name='USER'

To fix the problem:

1- Go In Security( Locked User)

2- In Miscellaneous, increase the Number of Allowed Failed Logon Attemps (

You can using this value INVALID_CONNECT_ATTEMPTS this users).

BR,

Tobias