6.97 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 |
---|---|---|---|
|
|
|
Name of the user |
|
|
|
ID number of the user |
|
|
|
This column is deprecated in favor of the |
|
|
|
Account status:
|
|
|
|
Date the account was locked if account status was |
|
|
|
Date of expiration of the account |
|
|
|
Default tablespace for data |
|
|
|
Name of the default tablespace for temporary tables or the name of a tablespace group |
|
|
|
Default local temporary tablespace for the user |
|
|
|
User creation date |
|
|
|
User resource profile name |
|
|
|
Initial resource consumer group for the user |
|
|
|
User external name. For centrally managed users, if the database user mapping is an exclusive mapping, then this will be the directory service DN for the user. If this database user is a shared schema, it will be the DN of a group. |
|
|
|
Shows the list of versions of the password hashes (also known as "verifiers") existing for the account. The values for this column can include:
For more information about the 12C verifier, see Oracle Database Concepts. Note that any combination of these verifiers can exist for any given account. |
|
|
|
Indicates whether editions have been enabled for the corresponding user ( |
|
|
|
Indicates the authentication mechanism for the user:
|
|
|
|
Indicates whether a user can connect directly ( For more information about creating proxy user accounts and authorizing users to connect through them, see Oracle Database Security Guide. |
|
|
|
Indicates whether a given user is common. Possible values
|
|
|
|
The time of the last user login This column is not populated when a user connects to the database with administrative privileges, that is, |
|
|
|
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 |
|
|
|
Indicates whether the user definition was inherited from another container ( |
|
|
|
Default collation for the user’s schema |
|
|
|
Indicates whether this user is a common user created by an implicit application ( |
|
|
|
In a sharded database, the value in this column indicates whether the user was created with shard DDL enabled. The possible values are:
In a non-sharded database, the value in this column is always |
|
|
Date on which the user's password was last set This column is populated only when the value of the |
Footnote 1 This column is available starting with Oracle Database 19c.
See Also:
-
Oracle Database Security Guide for information about creating schema only accounts where the schema user has no password
-
Using Oracle Sharding for more information about sharded database management