[Home] [Help] [Dependency Information]
Object Name: | USER_USERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Information about the current user
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. |
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;
|
|
|