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.KU$_XSPRIN_VIEW

Object Details

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

[View Source]

Columns

Name	Datatype	Length
VERS_MAJOR	CHAR	(1)
VERS_MINOR	CHAR	(1)
PRIN_ID	NUMBER
TYPE	NUMBER
GUID	RAW	(16)
EXT_SRC	VARCHAR2	(128)
START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)
END_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)
SCHEMA	VARCHAR2	(128)
TABLESPACE	VARCHAR2	(30)
PROFILE_NUM	NUMBER
CREDENTIAL	VARCHAR2	(128)
FAILEDLOGINS	NUMBER
ENABLE	NUMBER
DURATION	NUMBER
SYSTEM	NUMBER
SCOPE	NUMBER
POWNER	VARCHAR2	(128)
PNAME	VARCHAR2	(128)
PFNAME	VARCHAR2	(128)
OBJACL_NUM	NUMBER
NOTE	VARCHAR2	(4000)
STATUS	NUMBER
CTIME	TIMESTAMP(6)	(11)
MTIME	TIMESTAMP(6)	(11)
PTIME	DATE
EXPTIME	DATE
LTIME	DATE
LSLOGONTIME	DATE
ASTATUS	NUMBER
VERIFIER	VARCHAR2	(256)
VERIFIER_TYPE	NUMBER
DESCRIPTION	VARCHAR2	(4000)

Query Text

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


SELECT VERS_MAJOR
,      VERS_MINOR
,      PRIN_ID
,      TYPE
,      GUID
,      EXT_SRC
,      START_DATE
,      END_DATE
,      SCHEMA
,      TABLESPACE
,      PROFILE_NUM
,      CREDENTIAL
,      FAILEDLOGINS
,      ENABLE
,      DURATION
,      SYSTEM
,      SCOPE
,      POWNER
,      PNAME
,      PFNAME
,      OBJACL_NUM
,      NOTE
,      STATUS
,      CTIME
,      MTIME
,      PTIME
,      EXPTIME
,      LTIME
,      LSLOGONTIME
,      ASTATUS
,      VERIFIER
,      VERIFIER_TYPE
,      DESCRIPTION
FROM SYS.KU$_XSPRIN_VIEW;

Dependencies

[top of page]

SYS.KU$_XSPRIN_VIEW references the following:

SYS: KU$_XSPRIN_T; PROFNAME$; STANDARD - show dependent code; XS$PRIN; XS$VERIFIERS

SYS.KU$_XSPRIN_VIEW is referenced by following:

SYS: KU$_XSOBJ_VIEW; KU$_XSUSER_VIEW