登録ユーザの確認方法

SELECT USERNAME,
DEFAULT_TABLESPACE,
TEMPORARY_TABLESPACE,
PROFILE,
CREATED,
ACCOUNT_STATUS
FROM DBA_USERS
;