DBA_USERS

Information about all users of the database

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

Related:

Simon Sheppard
SS64.com