[Home] [Help] [Dependency Information]

TABLE: SYS.XS$PRIN

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: XS$PRIN_PK

1. PRIN#

Indexes

Index	Type	Uniqueness	Tablespace	Column
XS$PRIN_PK	NORMAL	UNIQUE	SYSTEM	PRIN#

Foreign Keys

Table		Foreign Table	Foreign Key Column
XS$PRIN		XS$OBJ	XS$PRIN PRIN#
XS$PROXY_ROLE		XS$PRIN	XS$PROXY_ROLE ROLE#
XS$ROLE_GRANT		XS$PRIN	XS$ROLE_GRANT GRANTEE#
XS$ROLE_GRANT		XS$PRIN	XS$ROLE_GRANT ROLE#

Columns

Query Text

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

SELECT PRIN#
,      TYPE
,      GUID
,      EXT_SRC
,      START_DATE
,      END_DATE
,      SCHEMA
,      TABLESPACE
,      CREDENTIAL
,      FAILEDLOGINS
,      ENABLE
,      DURATION
,      SYSTEM
,      SCOPE
,      POWNER
,      PNAME
,      PFNAME
,      OBJACL#
,      NOTE
,      STATUS
,      CTIME
,      MTIME
,      DESCRIPTION
,      PROFILE#
,      PTIME
,      EXPTIME
,      LTIME
,      LSLOGONTIME
,      ASTATUS
FROM SYS.XS$PRIN;

Dependencies

[top of page]

SYS.XS$PRIN does not reference any database object

SYS.XS$PRIN is referenced by following:

SYS

DBA_XS_DYNAMIC_ROLES

DBA_XS_PRINCIPALS

DBA_XS_ROLES

DBA_XS_USERS

DBMS_FEATURE_RAS - show dependent code

KU$_XSPRIN_VIEW

KU$_XSROLE_VIEW

KU$_XSUSER_VIEW

USER_XS_PASSWORD_LIMITS

XS_ACL_INT - show dependent code

XS_DIAG_INT - show dependent code

XS_PRINCIPAL_INT - show dependent code