1. System Tables and Views Reference
  2. System Tables and Views 
  3. SYS.ALL_USERS

SYS.ALL_USERS

The ALL_USERS view lists all users of the database that are visible to the current user.

Related views

  • SYS.DBA_USERS describes all users of the database and contains more columns than ALL_USERS.

  • SYS.USER_USERS describes the current user of the database and contains more columns than ALL_USERS.

Columns

Column name Type Description

USERNAME

VARCHAR2(30) INLINE

Name of the user

USER_ID

TT_INTEGER NOT NULL

ID number of the user

CREATED

TT_TIMESTAMP NOT NULL

Date the user was created