DBA_USERS

Information about all users of the database

Name Datatype Length Mandatory Comments
USERNAME VARCHAR2 (30) Yes Name of the user
USER_ID NUMBER
Yes ID number of the user
PASSWORD VARCHAR2 (30)
Encrypted password
ACCOUNT_STATUS VARCHAR2 (32) Yes
LOCK_DATE DATE

EXPIRY_DATE DATE

DEFAULT_TABLESPACE VARCHAR2 (30) Yes Default tablespace for data
TEMPORARY_TABLESPACE VARCHAR2 (30) Yes Default tablespace for temporary tables
CREATED DATE
Yes User creation date
PROFILE VARCHAR2 (30) Yes User resource profile name
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2 (30)
User's initial consumer group
EXTERNAL_NAME VARCHAR2 (4000)
User external name

Usage


  cursor cur_schema
  is select username
  from dba_users
  order by username;