Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

USER_USERS

USER_USERS describes the current user.

Column Datatype NULL Description
USERNAME VARCHAR2(128) NOT NULL Name of the user
USER_ID NUMBER NOT NULL ID number of the user
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
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(128)   Initial resource consumer group for the user
EXTERNAL_NAME VARCHAR2(4000)   User external name
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)

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.

See Also:

"DBA_USERS"