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

TABLE: SYS.XS$AGGR_PRIV

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: XS$AGGR_PRIV_UK
  1. ColumnSC#
  2. ColumnAGGR_PRIV#
  3. ColumnIMPLIED_PRIV#
Indexes
Index Type Uniqueness Tablespace Column
XS$AGGR_PRIV_UK NORMAL UNIQUE TablespaceSYSTEM ColumnSC#
ColumnAGGR_PRIV#
ColumnIMPLIED_PRIV#
Foreign Keys
Table
Foreign Table Foreign Key Column
XS$AGGR_PRIV XS$AGGR_PRIV_FK2 TableXS$OBJ XS$AGGR_PRIV IMPLIED_PRIV#
XS$AGGR_PRIV XS$AGGR_PRIV_FK1 TableXS$PRIV XS$AGGR_PRIV SC#
XS$AGGR_PRIV AGGR_PRIV#
Columns
Name Datatype Length Mandatory Comments
SC# NUMBER

AGGR_PRIV# NUMBER

IMPLIED_PRIV# NUMBER

Query Text

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


SELECT SC#
,      AGGR_PRIV#
,      IMPLIED_PRIV#
FROM SYS.XS$AGGR_PRIV;

Dependencies

[top of page]

SYS.XS$AGGR_PRIV does not reference any database object

SYS.XS$AGGR_PRIV is referenced by following:

SchemaSYS
ViewDBA_XS_IMPLIED_PRIVILEGES
ViewKU$_XSAGGPRIV_VIEW
Package BodyXS_DIAG_INT - show dependent code
Package BodyXS_SECURITY_CLASS_INT - show dependent code