USER_USERS

Information about the current user

Columns
   ___________________________
 
   USERNAME
      Name of the user
   USER_ID
      ID number of the user
   ACCOUNT_STATUS
      --
   LOCK_DATE
      --
   EXPIRY_DATE
      --
   DEFAULT_TABLESPACE
      Default tablespace for data
   TEMPORARY_TABLESPACE
      Default tablespace for temporary tables
   CREATED
      User creation date
   INITIAL_RSRC_CONSUMER_GROUP
      User's initial consumer group
   EXTERNAL_NAME
      User external name

Related:

Simon Sheppard
SS64.com