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

VIEW: SYS._BASE_USER

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
USER# NUMBER
Yes
TYPE# NUMBER
Yes
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

SPARE6 DATE

NAME VARCHAR2 (128)
Query Text

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


SELECT USER#
,      TYPE#
,      DATATS#
,      TEMPTS#
,      CTIME
,      PTIME
,      EXPTIME
,      LTIME
,      RESOURCE$
,      AUDIT$
,      DEFROLE
,      DEFGRP#
,      DEFGRP_SEQ#
,      ASTATUS
,      LCOUNT
,      DEFSCHCLASS
,      EXT_USERNAME
,      SPARE1
,      SPARE2
,      SPARE6
,      NAME
FROM SYS._BASE_USER;

Dependencies

[top of page]

SYS._BASE_USER references the following:

SchemaSYS
TableUSER$
SYS._BASE_USER is referenced by following:

SchemaLBACSYS
ViewOLS$POLICY_COLUMNS
Package BodySA_USER_ADMIN - show dependent code
SchemaSYS
ViewALL_CONS_OBJ_COLUMNS
ViewALL_NESTED_TABLES
ViewALL_NESTED_TABLE_COLS
ViewALL_OBJECT_TABLES
ViewALL_TAB_COLS_V$
ViewALL_VARRAYS
ViewCOL
ViewDBA_CONS_OBJ_COLUMNS
ViewDBA_CONTAINER_DATA
ViewDBA_NESTED_TABLES
ViewDBA_NESTED_TABLE_COLS
ViewDBA_OBJECT_TABLES
ViewDBA_TAB_COLS_V$
ViewDBA_VARRAYS
ViewINT$INT$DBA_CONSTRAINTS
ViewUSER_CONS_OBJ_COLUMNS
ViewUSER_NESTED_TABLES
ViewUSER_NESTED_TABLE_COLS
ViewUSER_OBJECT_TABLES
ViewUSER_TAB_COLS_V$
ViewUSER_VARRAYS