[Home] [Help] [Dependency Information]
Object Name: | XS$PRIN |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XS$PRIN_PK | NORMAL | UNIQUE | SYSTEM | PRIN# |
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# |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRIN# | NUMBER | Yes | ||
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) | ||
CREDENTIAL | VARCHAR2 | (128) | ||
FAILEDLOGINS | NUMBER | |||
ENABLE | NUMBER | |||
DURATION | NUMBER | |||
SYSTEM | NUMBER | |||
SCOPE | NUMBER | |||
POWNER | VARCHAR2 | (128) | ||
PNAME | VARCHAR2 | (128) | ||
PFNAME | VARCHAR2 | (128) | ||
OBJACL# | NUMBER | |||
NOTE | VARCHAR2 | (4000) | ||
STATUS | NUMBER | |||
CTIME | TIMESTAMP(6) | (11) | ||
MTIME | TIMESTAMP(6) | (11) | ||
DESCRIPTION | VARCHAR2 | (4000) | ||
PROFILE# | NUMBER | |||
PTIME | DATE | |||
EXPTIME | DATE | |||
LTIME | DATE | |||
LSLOGONTIME | DATE | |||
ASTATUS | NUMBER |
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;
SYS.XS$PRIN does not reference any database object
SYS.XS$PRIN is referenced by following:
|
|
|