ALL_USERS

ALL_USERS lists all users of the database visible to the current user. This view does not describe the users (see the related views).

Related Views

• DBA_USERS describes all users in the database, and contains more columns than ALL_USERS. See "DBA_USERS".

• USER_USERS describes the current user, and contains more columns that ALL_USERS. See "USER_USERS".

  Column	Datatype	NULL	Description
  USERNAME	VARCHAR2(30)	NOT NULL	Name of the user
  USER_ID	NUMBER	NOT NULL	ID number of the user
  CREATED	DATE	NOT NULL	User creation date