user stati in oracle

March 18, 2013 — 3 Comments

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 :)

Advertisements

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s