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, PROFILE, PASSWORD_VERSIONS, EDITIONS_ENABLED, AUTHENTICATION_TYPE , and LAST_LOGIN columns.

Column	Datatype	NULL	Description
`USERNAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the user
`USER_ID`	`NUMBER`	`NOT NULL`	ID number of the user
`PASSWORD`	`VARCHAR2(4000)`		This column is deprecated in favor of the `AUTHENTICATION_TYPE` column
`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(128)`	`NOT NULL`	User resource profile name
`INITIAL_RSRC_CONSUMER_GROUP`	`VARCHAR2(128)`		Initial resource consumer group for the user
`EXTERNAL_NAME`	`VARCHAR2(4000)`		User external name
`PASSWORD_VERSIONS`	`VARCHAR2(12)`		Shows the list of versions of the password hashes (also known as "verifiers") existing for the account. The `PASSWORD_VERSIONS` column value includes `10G` if an old case-insensitive ORCL hash exists, `11G` if a SHA-1 hash exists, and `12C` if a de-optimized PBKDF2-based hash exists. For more information about the 12C verifier, see Oracle Database Security Guide. Note that any combination of these verifiers can exist for any given account.
`EDITIONS_ENABLED`	`VARCHAR2(1)`		Indicates whether editions have been enabled for the corresponding user (`Y`) or not (`N`)
`AUTHENTICATION_TYPE`	`VARCHAR2(8)`		Indicates the authentication mechanism for the user: `EXTERNAL` - `CREATE USER` `user1` `IDENTIFIED EXTERNALLY;` `GLOBAL` - `CREATE USER` `user2` `IDENTIFIED GLOBALLY;` `PASSWORD` - `CREATE USER` `user3` `IDENTIFIED BY` `user3;`
`PROXY_ONLY_CONNECT`	`VARCHAR2(1)`		Indicates whether a user can connect directly (`N`) or whether the account can only be proxied (`Y`) by users who have proxy privileges for this account (that is, by users who have been granted the "connect through" privilege for this account). For more information about creating proxy user accounts and authorizing users to connect through them, see Oracle Database Security Guide.
`COMMON`	`VARCHAR2(3)`		Indicates whether a given user is common. Possible values `YES` if a user is common `NO` if a user is local (not common)
`LAST_LOGIN`	`TIMESTAMP(9) WITH TIME ZONE`		The time of the last user login.
`ORACLE_MAINTAINED`	`VARCHAR2(1)`		Denotes whether the user was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql). A user for which this column has the value `Y` must not be changed in any way except by running an Oracle-supplied script.