did you ever wonder which status a user in oracle can be in ? there is a small table which answers this question ( this is on 11.2.0.3 ):

```SQL> select * from sys.user_astatus_map order by 1;

STATUS# STATUS
---------- --------------------------------
0 OPEN
1 EXPIRED
2 EXPIRED(GRACE)
4 LOCKED(TIMED)
5 EXPIRED & LOCKED(TIMED)
6 EXPIRED(GRACE) & LOCKED(TIMED)
8 LOCKED
9 EXPIRED & LOCKED
10 EXPIRED(GRACE) & LOCKED

9 rows selected.
```

don’t ask me what happened to status 3 and 7 :)

### 3 responses to user stati in oracle

1. 

Hi Daniel
This post of Pete Finnigan http://www.petefinnigan.com/weblog/archives/00000178.htm clarifies your question.

“Therefore we can now deduce why the values of 3 and 7 do not exist. The value for 3 could only be made up of:

1 (EXPIRED) + 2 (EXPIRED(GRACE)) = 3

This would not make sense as they are mutually exclusive. Next for the value of 7. This could only be made up of:

1 (EXPIRED) + 2 (EXPIRED(GRACE)) + 4 (LOCKED(TIMED)) = 7

Again the same problem with having EXPIRED and EXPIRED(GRACE) which are mutually exclusive. The same arguments could be applied to why values of 11 – 15 which would include again the same pair or LOCKED and LOCKED(TIMED) together.”

Regards
Xavier

2. 

Hi Daniel
This post of Pete Finnigan http://www.petefinnigan.com/weblog/archives/00000178.htm clarifies your question.

“Therefore we can now deduce why the values of 3 and 7 do not exist. The value for 3 could only be made up of:

1 (EXPIRED) + 2 (EXPIRED(GRACE)) = 3

This would not make sense as they are mutually exclusive. Next for the value of 7. This could only be made up of:

1 (EXPIRED) + 2 (EXPIRED(GRACE)) + 4 (LOCKED(TIMED)) = 7

Again the same problem with having EXPIRED and EXPIRED(GRACE) which are mutually exclusive. The same arguments could be applied to why values of 11 – 15 which would include again the same pair or LOCKED and LOCKED(TIMED) together.”

Regards
Xavier

• 

Hi Xavier,

thanks for the clarification and pointing this out.

Regards
Daniel

This site uses Akismet to reduce spam. Learn how your comment data is processed.