SQL> select * from user_astatus_map;
STATUS# STATUS
---------- --------------------------------
0 OPEN
1 EXPIRED
2 EXPIRED(GRACE)
4 LOCKED(TIMED)
8 LOCKED
5 EXPIRED & LOCKED(TIMED)
6 EXPIRED(GRACE) & LOCKED(TIMED)
9 EXPIRED & LOCKED
10 EXPIRED(GRACE) & LOCKED
9 rows selected.
• OPEN – Account is accessible.
• EXPIRED – Account is expired. Access is denied.
• EXPIRED(GRACE) – Account is expired but still accessible. You will be given x days of time to change the password to eliminate the status to OPEN.
• LOCKED(TIMED) – Account is locked due to unsuccessful login attemps (FAILED_LOGIN_ATTEMPTS)
• LOCKED – Account is locked by a administrator.
• EXPIRED & LOCKED(TIMED)
• EXPIRED(GRACE) & LOCKED(TIMED)
• EXPIRED & LOCKED
• EXPIRED(GRACE) & LOCKED
The status is based on numbering combination. As an example, the status EXPIRED(GRACE) & LOCKED is 2 + 10 = 10. So number 10 is EXPIRED(GRACE) & LOCKED.
