Q
Problem solve Get help with specific problems with your technologies, process and projects.

Tracking consecutive failed logins

How can you track consecutive failed logins? I have turned on connection auditing and thought user$.lcount would give me what I wanted but the column is not being updated.
The user$.lcount column does track consecutive failed logins, but only when you have set up a maximum number of failed login attempts (using profiles and the FAILED_LOGIN_ATTEMPTS limit). If you have FAILED_LOGIN_ATTEMPTS UNLIMITED (check DBA_PROFILES), then user$.lcount will remain 0 no matter how many failed attempts a user tries. I suppose that you could, in theory, set FAILED_LOGIN_ATTEMPTS to some very high number (the upper limit in 9iR2 appears to be somewhere between 2.1 and 2.2 million) and that would essentially be unlimited. If you have a user that actually tries to login with an incorrect password 2.1 million times, you should definitely nominate them for the darwin award! :)

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close