[Home] [Help] [Dependency Information]

TABLE: SYS.XS$OBJ

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: XS$OBJ_PK

1. ID

Unique Key: XS$OBJ_UK

1. NAME
2. OWNER
3. TENANT
4. TYPE

Indexes

Index	Type	Uniqueness	Tablespace	Column
XS$OBJ_PK	NORMAL	UNIQUE	SYSTEM	ID
XS$OBJ_UK	NORMAL	UNIQUE	SYSTEM	NAME OWNER TENANT TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
XS$OBJ		XS$TENANT	XS$OBJ TENANT
XS$ACE_PRIV		XS$OBJ	XS$ACE_PRIV PRIV#
XS$ACL		XS$OBJ	XS$ACL SC#
XS$ACL		XS$OBJ	XS$ACL PARENT_ACL#
XS$ACL		XS$OBJ	XS$ACL ACL#
XS$AGGR_PRIV		XS$OBJ	XS$AGGR_PRIV IMPLIED_PRIV#
XS$ATTR_SEC		XS$OBJ	XS$ATTR_SEC PRIV#
XS$DSEC		XS$OBJ	XS$DSEC XDSID#
XS$INSTSET_ACL		XS$OBJ	XS$INSTSET_ACL ACL#
XS$NSTMPL		XS$OBJ	XS$NSTMPL NS#
XS$PRIN		XS$OBJ	XS$PRIN PRIN#
XS$PRIV		XS$OBJ	XS$PRIV PRIV#
XS$PROXY_ROLE		XS$OBJ	XS$PROXY_ROLE PROXY#
XS$ROLESET		XS$OBJ	XS$ROLESET RSID#
XS$ROLESET_ROLES		XS$OBJ	XS$ROLESET_ROLES ROLE#
XS$SECCLS		XS$OBJ	XS$SECCLS SC#
XS$SECCLS_H		XS$OBJ	XS$SECCLS_H PARENT_SC#

Columns

Query Text

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

SELECT NAME
,      WS
,      OWNER
,      TENANT
,      ID
,      TYPE
,      STATUS
,      FLAGS
,      EARLY_DEP_CNT
,      LATE_DEP_CNT
,      ACLID
FROM SYS.XS$OBJ;

Dependencies

[top of page]

SYS.XS$OBJ does not reference any database object

SYS.XS$OBJ is referenced by following:

SYS

DBA_XS_ACES

DBA_XS_ACLS

DBA_XS_ACL_PARAMETERS

DBA_XS_ACTIVE_SESSIONS

DBA_XS_COLUMN_CONSTRAINTS

DBA_XS_DYNAMIC_ROLES

DBA_XS_EXTERNAL_PRINCIPALS

DBA_XS_IMPLIED_PRIVILEGES

DBA_XS_INHERITED_REALMS

DBA_XS_MODIFIED_POLICIES

DBA_XS_NS_TEMPLATES

DBA_XS_NS_TEMPLATE_ATTRIBUTES

DBA_XS_OBJECTS

DBA_XS_POLICIES

DBA_XS_PRINCIPALS

DBA_XS_PRIVILEGES

DBA_XS_PROXY_ROLES

DBA_XS_REALM_CONSTRAINTS

DBA_XS_ROLES

DBA_XS_ROLE_GRANTS

DBA_XS_SECURITY_CLASSES

DBA_XS_SECURITY_CLASS_DEP

DBA_XS_SESSIONS

DBA_XS_USERS

DBMS_FEATURE_RAS - show dependent code

KU$_XSACE_VIEW

KU$_XSACLPARAM_VIEW

KU$_XSACL_VIEW

KU$_XSAGGPRIV_VIEW

KU$_XSATTRSEC_VIEW

KU$_XSNSPACE_VIEW

KU$_XSOBJ_VIEW

KU$_XSPOLICY_PARAM_VIEW

KU$_XSPOLICY_VIEW

KU$_XSPRIV_VIEW

KU$_XSROLESET_VIEW

KU$_XSROLE_GRANT_VIEW

KU$_XSROLE_VIEW

KU$_XSSCLASS_VIEW

KU$_XSSECCLSH_VIEW

KU$_XSUSER_VIEW

XS_ADMIN_UTIL - show dependent code

XS_DATA_SECURITY_INT - show dependent code

XS_DIAG_INT - show dependent code

XS_NAMESPACE_INT - show dependent code