--what Oracle users are defined, and what are their settings?

column username             format a20
column account_status       format a10
column default_tablespace   format a15
column temporary_tablespace format a15
column created              format a10

select username,account_status,default_tablespace,temporary_tablespace,created
from dba_users;