Oracle DB User Profile Option Values


Oracle DB User Profile Option Values
FAILED_LOGIN_ATTEMPTS
Means for how many times you can try to login.. After these many sequential unsuccessful tris to login, the user account will be locked for the days specified in PASSWORD_LOCK_TIME. (i.e. LOCKED (TIMED)).
PASSWORD_LOCK_TIME
 for this much amount of time, your password wil be locked, if your account is locked because you are failed to login successfully .
PASSWORD_GRACE_TIME
the number of days, after your password expires. During that time, user can use that password, but reminded to change password.
PASSWORD_LIFE_TIME
the number of days, the password can remain in force.
All the possible values are decided by below mentioned parameters
OPEN
you can use this acccount to login.
EXPIRED
Account is expired as you have tried to unsuccessfully login for 3 times.
EXPIRED(GRACE)
Means, account is expried but grace is given to change the password.
LOCKED(TIMED)
Account is locked as you have tried to unsuccessfully login for FAILED_LOGIN_ATTEMPTS times.
EXPIRED(GRACE) & LOCKED(TIMED)

EXPIRED & LOCKED

EXPIRED(GRACE) & LOCKED