【oracle笔记】dba_ all_ user_ 表视图

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