SYS.USER_USERS

The USER_USERS view describes the current user.

Related views

SYS.ALL_USERS lists all users of the database that are accessible to the current user.
SYS.DBA_USERS describes all users of the database.

Columns

Column	Type	Description
USERNAME	VARCHAR2(30) NOT NULL	Name of the user
USER_ID	TT_INTEGER NOT NULL	ID number of the user
ACCOUNT_STATUS	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 always NULL.
EXTERNAL_NAME	VARCHAR2(4000)	Value is always NULL.