DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.USER_USERS

Object Details
Object Name: USER_USERS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about the current user

[View Source]

Columns
Name Datatype Length Mandatory Comments
USERNAME VARCHAR2 (128) Yes Name of the user
USER_ID NUMBER
Yes ID number of the user
ACCOUNT_STATUS VARCHAR2 (32) Yes
LOCK_DATE DATE

EXPIRY_DATE DATE

DEFAULT_TABLESPACE VARCHAR2 (30) Yes Default tablespace for data
TEMPORARY_TABLESPACE VARCHAR2 (30) Yes Default tablespace for temporary tables
CREATED DATE
Yes User creation date
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2 (128)
User's initial consumer group
EXTERNAL_NAME VARCHAR2 (4000)
User external name
PROXY_ONLY_CONNECT VARCHAR2 (1)
Whether this user can connect only through a proxy
COMMON VARCHAR2 (3)
Indicates whether this user is Common
ORACLE_MAINTAINED VARCHAR2 (1)
Denotes whether the user was created, and is maintained, by Oracle-supplied scripts. A user for which this has the value Y must not be changed in any way except by running an Oracle-supplied script.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USERNAME
,      USER_ID
,      ACCOUNT_STATUS
,      LOCK_DATE
,      EXPIRY_DATE
,      DEFAULT_TABLESPACE
,      TEMPORARY_TABLESPACE
,      CREATED
,      INITIAL_RSRC_CONSUMER_GROUP
,      EXTERNAL_NAME
,      PROXY_ONLY_CONNECT
,      COMMON
,      ORACLE_MAINTAINED
FROM SYS.USER_USERS;

Dependencies

[top of page]

SYS.USER_USERS references the following:

SchemaSYS
TablePROFILE$
TableRESOURCE_GROUP_MAPPING$
TableTS$
TableUSER$
TableUSER_ASTATUS_MAP
SYS.USER_USERS is referenced by following:

SchemaPUBLIC
SynonymUSER_USERS
SchemaSYS
Package BodyDBMS_SQLTCB_INTERNAL - show dependent code
Package BodyDBMS_WRR_INTERNAL - show dependent code
ViewUSER_GOLDENGATE_PRIVILEGES
ViewUSER_REPCATLOG
ViewUSER_REPGENERATED
ViewUSER_REPGENOBJECTS
ViewUSER_REPGROUP
ViewUSER_REPKEY_COLUMNS
ViewUSER_REPOBJECT
ViewUSER_REPPROP
ViewUSER_REPSCHEMA
ViewUSER_REPSITES