eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
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:

SYS: USER$

SYS._BASE_USER is referenced by following:

LBACSYS: OLS$POLICY_COLUMNS; SA_USER_ADMIN - show dependent code
SYS: ALL_CONS_OBJ_COLUMNS; ALL_NESTED_TABLES; ALL_NESTED_TABLE_COLS; ALL_OBJECT_TABLES; ALL_TAB_COLS_V$; ALL_VARRAYS; COL; DBA_CONS_OBJ_COLUMNS; DBA_CONTAINER_DATA; DBA_NESTED_TABLES; DBA_NESTED_TABLE_COLS; DBA_OBJECT_TABLES; DBA_TAB_COLS_V$; DBA_VARRAYS; INT$INT$DBA_CONSTRAINTS; USER_CONS_OBJ_COLUMNS; USER_NESTED_TABLES; USER_NESTED_TABLE_COLS; USER_OBJECT_TABLES; USER_TAB_COLS_V$; USER_VARRAYS