When Is Failed Login Count Reset
(Doc ID 2945963.1)
Last updated on MAY 07, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 18.9.0.0.0 [Release 10.1 to 18]Information in this document applies to any platform.
Goal
NOTE: In the images and/or the document content below, the user information and data like schema name, profile name used represents fictitious data and are used to provide an illustrative example only. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
Note: In the following paragraphs user 'JO' and profile name 'lcountest_profile' are used only as an example.|
Failed login count for an user is recorded in user$.lcount and it increases when that user fails to login.
This typically happens when an incorrect password is provided during database connection time:
Now question is:
When is failed login count (user$.lcount) reset ?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| 1. When user acount is unlocked |
| 2. When correct password is provided so that a successfuly login happens |
| 3. What if database restarts ? |
| 4. What if changing profile for a user ? |
| References |