DBA_USERS describes all users of the database, and contains more column than 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).
USER_users describes the current user,and contains more columns than ALL_USERS.
DBA > ALL >USER
why contains more columns than ALL_USERS?
DBA_USERS
USERNAME | USER_ID | PASSWORD | ACCOUNT_STATUS | LOCK_DATE | EXPIRY_DATE | DEFAULT_TABLESPACE | TEMPORARY_TABLESPACE | CREATED | PROFILE | INITIAL_RSRC_CONSUMER_GROUP | EXTERNAL_NAME |
---|
ALL_USERS
USERNAME | USER_ID | CREATED |
---|
USER_USERS
USERNAME | USER_ID | ACCOUNT_STATUS | LOCK_DATE | EXPIRY_DATE | DEFAULT_TABLESPACE | TEMPORARY_TABLESPACE | CREATED | INITIAL_RSRC_CONSUMER_GROUP | EXTERNAL_NAME |
---|