DBA_USERS

Information about all users of the database

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

Related Commands:

 DBA_TS_QUOTAS    USER_TS_QUOTAS 

 SYS.USER$ (Password Expiry)

Simon Sheppard
SS64.com