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


TABLE: SYS.XS$PRIV

Object Details
Object Name: XS$PRIV
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: XS$SC_PRIV_UK
  1. ColumnSC#
  2. ColumnPRIV#
Indexes
Index Type Uniqueness Tablespace Column
XS$SC_PRIV_UK NORMAL UNIQUE TablespaceSYSTEM ColumnSC#
ColumnPRIV#
XS$PRIV_I1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnPRIV#
Foreign Keys
Table
Foreign Table Foreign Key Column
XS$PRIV XS$PRIV_FK1 TableXS$OBJ XS$PRIV PRIV#
XS$PRIV XS$PRIV_FK2 TableXS$SECCLS XS$PRIV SC#
TableXS$AGGR_PRIV XS$AGGR_PRIV_FK1 XS$PRIV XS$AGGR_PRIV SC#
XS$AGGR_PRIV AGGR_PRIV#
Columns
Name Datatype Length Mandatory Comments
PRIV# NUMBER

SC# NUMBER

CTIME TIMESTAMP(6) (11)
MTIME TIMESTAMP(6) (11)
DESCRIPTION VARCHAR2 (4000)
Query Text

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


SELECT PRIV#
,      SC#
,      CTIME
,      MTIME
,      DESCRIPTION
FROM SYS.XS$PRIV;

Dependencies

[top of page]

SYS.XS$PRIV does not reference any database object

SYS.XS$PRIV is referenced by following:

SchemaSYS
ViewDBA_XS_PRIVILEGES
ProcedureDBMS_FEATURE_RAS - show dependent code
ViewKU$_XSPRIV_VIEW
Package BodyXS_DIAG_INT - show dependent code
Package BodyXS_SECURITY_CLASS_INT - show dependent code