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


TABLE: SYS.XS$ACE

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: XS$ACE_PK
  1. ColumnACL#
  2. ColumnORDER#
Indexes
Index Type Uniqueness Tablespace Column
XS$ACE_PK NORMAL UNIQUE TablespaceSYSTEM ColumnACL#
ColumnORDER#
Foreign Keys
Table
Foreign Table Foreign Key Column
XS$ACE XS$ACE_FK1 TableXS$ACL XS$ACE ACL#
TableXS$ACE_PRIV XS$ACE_PRIV_FK1 XS$ACE XS$ACE_PRIV ACL#
XS$ACE_PRIV ACE_ORDER#
Columns
Name Datatype Length Mandatory Comments
ACL# NUMBER
Yes
ORDER# NUMBER
Yes
ACE_TYPE NUMBER

PRIN# NUMBER

PRIN_TYPE NUMBER

PRIN_INVERT NUMBER

START_DATE TIMESTAMP(6) (11)
END_DATE TIMESTAMP(6) (11)
ACE_FLAG NUMBER

Query Text

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


SELECT ACL#
,      ORDER#
,      ACE_TYPE
,      PRIN#
,      PRIN_TYPE
,      PRIN_INVERT
,      START_DATE
,      END_DATE
,      ACE_FLAG
FROM SYS.XS$ACE;

Dependencies

[top of page]

SYS.XS$ACE does not reference any database object

SYS.XS$ACE is referenced by following:

SchemaSYS
ViewDBA_XS_ACES
ProcedureDBMS_FEATURE_RAS - show dependent code
ViewKU$_XSACE_VIEW
Package BodyXS_ACL_INT - show dependent code
Package BodyXS_ADMIN_UTIL - show dependent code
Package BodyXS_DIAG_INT - show dependent code
Package BodyXS_PRINCIPAL_INT - show dependent code
Package BodyXS_SECURITY_CLASS_INT - show dependent code