SYS.DBA_USERS

The DBA_USERS view describes all users of the database.

Related views

SYS.ALL_USERS view lists all users of the database that are visible to the current user.
SYS.USER_USERS view describes the current user.

Columns

Column	Type	Description.
USER_NAME	VARCHAR2(30) NOT NULL	Name of the user
USER_ID	TT_INTEGER NOT NULL	ID number of the user
ACCOUNT_STATUS	TT_VARCHAR2(32) NOT NULL	Value is OPEN.
LOCK_DATE	TT_TIMESTAMP	Value is NULL.
EXPIRY_DATE	TT_TIMESTAMP	Value is NULL.
DEFAULT_TABLESPACE	VARCHAR2(30) NOT NULL	Value is USERS.
TEMPORARY_TABLESPACE	VARCHAR2(30) NOT NULL	Value is TEMP.
CREATED	TT_TIMESTAMP NOT NULL	Date when the user was created
INITIAL_RSRC_CONSUMER_GROUP	VARCHAR2(30)	Value is NULL.
EXTERNAL_NAME	VARCHAR2(4000)	Value is NULL.