oracle user_users,dba_users,all_users

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

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

17 篇文章

订阅专栏

本文介绍了Oracle数据库中三种用户视图DBA_*、ALL_*及USER_*的区别与用途。DBA_*视图为DBA提供了所有对象的信息；ALL_*视图显示了特定用户可访问的所有对象；USER_*视图则专注于该用户的对象详情。

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