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


VIEW: SYS.EXU8USR

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (128) Yes
USERID NUMBER
Yes
PASSWD VARCHAR2 (4000)
DEFROLE VARCHAR2 (1)
DATATS VARCHAR2 (30) Yes
TEMPTS VARCHAR2 (30)
PROFILE# NUMBER
Yes
PROFNAME VARCHAR2 (128) Yes
ASTATUS NUMBER
Yes
EXT_USERNAME VARCHAR2 (4000)
Query Text

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


SELECT NAME
,      USERID
,      PASSWD
,      DEFROLE
,      DATATS
,      TEMPTS
,      PROFILE#
,      PROFNAME
,      ASTATUS
,      EXT_USERNAME
FROM SYS.EXU8USR;

Dependencies

[top of page]

SYS.EXU8USR references the following:

SchemaSYS
TablePROFNAME$
TableTS$
TableUSER$
SYS.EXU8USR is referenced by following:

SchemaSYS
ViewEXU8USRU