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

VIEW: SYS.KU$_USER_VIEW

Object Details
Object Name: KU$_USER_VIEW
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
VERS_MAJOR CHAR (1)
VERS_MINOR CHAR (1)
USER_ID NUMBER

NAME VARCHAR2 (128)
TYPE_NUM NUMBER

PASSWORD VARCHAR2 (4000)
DATATS VARCHAR2 (30)
TEMPTS VARCHAR2 (30)
CTIME VARCHAR2 (19)
PTIME VARCHAR2 (19)
EXPTIME VARCHAR2 (19)
LTIME VARCHAR2 (19)
PROFNUM NUMBER

PROFNAME VARCHAR2 (128)
USER_AUDIT VARCHAR2 (38)
DEFROLE NUMBER

DEFGRP_NUM NUMBER

DEFGRP_SEQ_NUM NUMBER

ASTATUS NUMBER

ASTATUS_12 NUMBER

LCOUNT NUMBER

DEFSCHCLASS VARCHAR2 (128)
EXT_USERNAME VARCHAR2 (4000)
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 VARCHAR2 (1000)
SPARE4_12 VARCHAR2 (1000)
SPARE5 VARCHAR2 (1000)
SPARE6 VARCHAR2 (19)
EDN_TYPES KU$_USER_EDITIONING_LIST_T (64)
Query Text

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


SELECT VERS_MAJOR
,      VERS_MINOR
,      USER_ID
,      NAME
,      TYPE_NUM
,      PASSWORD
,      DATATS
,      TEMPTS
,      CTIME
,      PTIME
,      EXPTIME
,      LTIME
,      PROFNUM
,      PROFNAME
,      USER_AUDIT
,      DEFROLE
,      DEFGRP_NUM
,      DEFGRP_SEQ_NUM
,      ASTATUS
,      ASTATUS_12
,      LCOUNT
,      DEFSCHCLASS
,      EXT_USERNAME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE4_12
,      SPARE5
,      SPARE6
,      EDN_TYPES
FROM SYS.KU$_USER_VIEW;

Dependencies

[top of page]

SYS.KU$_USER_VIEW references the following:

SchemaSYS
ViewKU$_USER_BASE_VIEW
TYPEKU$_USER_EDITIONING_LIST_T
ViewKU$_USER_EDITIONING_VIEW
TYPEKU$_USER_T
PL/SQL PackageSTANDARD - show dependent code

SYS.KU$_USER_VIEW is not referenced by any database object