Namespace User

In a sharded database, indicates whether the user is created with shard DDL enabled (YES) or not (NO).

The authentication mechanism for the user.

Indicates whether a given user is common(Y) or local(N).

The initial resource consumer group for the User.

The default collation for the user schema.

The default tablespace for data.

Indicates whether editions have been enabled for the corresponding user (Y) or not (N).

The external name of the user.

In a federated sharded database, indicates whether the user is an external shard user (YES) or not (NO).

Indicates whether the user is a common user created by an implicit application (YES) or not (NO).

Indicates whether the user definition is inherited from another container (YES) or not (NO).

The default local temporary tablespace for the user.

The name of the User.

Indicates whether the user was created and is maintained by Oracle-supplied scripts (such as catalog.sql or catproc.sql).

The list of existing versions of the password hashes (also known as "verifiers") for the account.

The profile name of the user.

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).

The status of the user account.

The name of the default tablespace for temporary tables or the name of a tablespace group.

The date and time the user was created.

The date and time of the expiration of the user account.

The date and time of the last user login. This column is not populated when a user connects to the database with administrative privileges, that is, AS { SYSASM | SYSBACKUP | SYSDBA | SYSDG | SYSOPER | SYSRAC | SYSKM }.

The date the account was locked, if the status of the account is LOCKED.

The date and time when the user password was last set. This column is populated only when the value of the AUTHENTICATION_TYPE column is PASSWORD. Otherwise, this column is null.