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


TABLE: SYS.XS$ACL

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: XS$ACL_PK
  1. ColumnACL#
Indexes
Index Type Uniqueness Tablespace Column
XS$ACL_PK NORMAL UNIQUE TablespaceSYSTEM ColumnACL#
Foreign Keys
Table
Foreign Table Foreign Key Column
XS$ACL XS$ACL_FK1 TableXS$OBJ XS$ACL ACL#
XS$ACL XS$ACL_FK3 TableXS$OBJ XS$ACL SC#
XS$ACL XS$ACL_FK2 TableXS$OBJ XS$ACL PARENT_ACL#
TableXS$ACE XS$ACE_FK1 XS$ACL XS$ACE ACL#
TableXS$ACL_PARAM XS$ACL_PARAM_FK2 XS$ACL XS$ACL_PARAM ACL#
TableXS$NSTMPL XS$NSTMP1_FK2 XS$ACL XS$NSTMPL ACL#
Columns
Name Datatype Length Mandatory Comments
ACL# NUMBER
Yes
SC# NUMBER

PARENT_ACL# NUMBER

ACL_FLAG 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 ACL#
,      SC#
,      PARENT_ACL#
,      ACL_FLAG
,      CTIME
,      MTIME
,      DESCRIPTION
FROM SYS.XS$ACL;

Dependencies

[top of page]

SYS.XS$ACL does not reference any database object

SYS.XS$ACL is referenced by following:

SchemaSYS
ViewDBA_XS_ACES
ViewDBA_XS_ACLS
ProcedureDBMS_FEATURE_RAS - show dependent code
ViewKU$_XSACL_VIEW
Package BodyXS_ACL_INT - show dependent code
Package BodyXS_DIAG_INT - show dependent code
Package BodyXS_SECURITY_CLASS_INT - show dependent code