[Home] [Help]
[Dependency Information]
Object Name: | USER$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | ![]() |
---|---|
PCT Free: | 0 |
PCT Used: | 0 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_USER1 | NORMAL | UNIQUE |
![]() |
![]() |
I_USER2 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER# | NUMBER | Yes | ||
NAME | VARCHAR2 | (128) | Yes | |
TYPE# | NUMBER | Yes | ||
PASSWORD | VARCHAR2 | (4000) | ||
DATATS# | NUMBER | Yes | ||
TEMPTS# | NUMBER | Yes | ||
CTIME | DATE | Yes | ||
PTIME | DATE | |||
EXPTIME | DATE | |||
LTIME | DATE | |||
RESOURCE$ | NUMBER | Yes | ||
AUDIT$ | VARCHAR2 | (38) | ||
DEFROLE | NUMBER | Yes | ||
DEFGRP# | NUMBER | |||
DEFGRP_SEQ# | NUMBER | |||
ASTATUS | NUMBER | Yes | ||
LCOUNT | NUMBER | Yes | ||
DEFSCHCLASS | VARCHAR2 | (128) | ||
EXT_USERNAME | VARCHAR2 | (4000) | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | VARCHAR2 | (1000) | ||
SPARE5 | VARCHAR2 | (1000) | ||
SPARE6 | DATE | |||
SPARE7 | VARCHAR2 | (4000) | ||
SPARE8 | VARCHAR2 | (4000) | ||
SPARE9 | NUMBER | |||
SPARE10 | NUMBER | |||
SPARE11 | TIMESTAMP(6) | (11) |
Cut, paste (and edit) the following text to query this object:
SELECT USER#
, NAME
, TYPE#
, PASSWORD
, DATATS#
, TEMPTS#
, CTIME
, PTIME
, EXPTIME
, LTIME
, RESOURCE$
, AUDIT$
, DEFROLE
, DEFGRP#
, DEFGRP_SEQ#
, ASTATUS
, LCOUNT
, DEFSCHCLASS
, EXT_USERNAME
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, SPARE7
, SPARE8
, SPARE9
, SPARE10
, SPARE11
FROM SYS.USER$;
SYS.USER$ does not reference any database object
SYS.USER$ is referenced by following:
|
|
|