Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_USERS

Information about the current user

Columns
   ___________________________
 
   USER_ID
      ID number of the user
   EXPIRY_DATE
   DEFAULT_TABLESPACE
      Default tablespace for data
   CREATED
      User creation date
   ACCOUNT_STATUS
   LOCK_DATE
   TEMPORARY_TABLESPACE
      Default tablespace for temporary tables
   EXTERNAL_NAME
      User external name
   INITIAL_RSRC_CONSUMER_GROUP
      User's initial consumer group
   USERNAME
      Name of the user

Related Commands:

 DBA_TS_QUOTAS    USER_TS_QUOTAS



Back to the Top

Simon Sheppard
SS64.com