select username, temporary_tablespace
from dba_users;