How do you check the User failed login attempts without auditing the user?
A user created with default profile and the profile is modified to have the resource name FAILED_LOGIN_ATTEMPTS set to 10. Now the user account will lock when the attempts to connect to the user is more than 10.
How do we verify that there are so many number of failed login attempts earlier.
Is auditing the user the only solution ?
You can find the FAILED_LOGIN_ATTEMPTS value from the lcount column of user$ table.
In order to check if the FAILED_LOGIN_ATTEMPTS is working or not , we need to try giving wrong passwords 10 times continuously without any successful attempts. Then 11th attempt will lock the user account. But if there is atleast one single successful attempt to connect to the user , the value resets to "0" again.