oracle user_users,dba_users,all_users

最新推荐文章于 2023-02-16 17:53:38 发布

转载最新推荐文章于 2023-02-16 17:53:38 发布 · 1.9k 阅读

224 篇文章

订阅专栏

本文详细解释了Oracle数据库中的三个用户视图：ALL_USERS、DBA_USERS和USER_USERS的功能及区别，并提供了各视图的列信息说明。

(2010-07-26 09:34:44)

标签：

here are from the oracle doc:

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 of the database, and contains more columns than ALL_USERS.
USER_USERS describes the current user, and contains more columns than ALL_USERS.

DBA_USERS

DBA_USERS describes all users of the database.

Related View

USER_USERS describes the current user. This view does not display the PASSWORD or PROFILE columns.

Column	Datatype	NULL	Description
`USERNAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the user
`USER_ID`	`NUMBER`	`NOT NULL`	ID number of the user
`PASSWORD`	`VARCHAR2(30)`		Encrypted password
`ACCOUNT_STATUS`	`VARCHAR2(32)`	`NOT NULL`	Account status: `OPEN` `EXPIRED` `EXPIRED(GRACE)` `LOCKED(TIMED)` `LOCKED` `EXPIRED & LOCKED(TIMED)` `EXPIRED(GRACE) & LOCKED(TIMED)` `EXPIRED & LOCKED` `EXPIRED(GRACE) & LOCKED`
`LOCK_DATE`	`DATE`		Date the account was locked if account status was`LOCKED`
`EXPIRY_DATE`	`DATE`		Date of expiration of the account
`DEFAULT_TABLESPACE`	`VARCHAR2(30)`	`NOT NULL`	Default tablespace for data
`TEMPORARY_TABLESPACE`	`VARCHAR2(30)`	`NOT NULL`	Name of the default tablespace for temporary tables or the name of a tablespace group
`CREATED`	`DATE`	`NOT NULL`	User creation date
`PROFILE`	`VARCHAR2(30)`	`NOT NULL`	User resource profile name
`INITIAL_RSRC_CONSUMER_GROUP`	`VARCHAR2(30)`		Initial resource consumer group for the user
`EXTERNAL_NAME`	`VARCHAR2(4000)`		User external name