VIEW: SYS.DBA_XS_SECURITY_CLASS_DEP

Source

View Text - Preformatted

select o1.name, o1.owner, o2.name, o2.owner
from sys.xs$obj o1, sys.xs$obj o2, sys.xs$seccls_h sh
where o1.id = sh.sc# and o2.id = sh.parent_sc#

View Text - HTML Formatted

SELECT O1.NAME
, O1.OWNER
, O2.NAME
, O2.OWNER FROM SYS.XS$OBJ O1
, SYS.XS$OBJ O2
, SYS.XS$SECCLS_H SH WHERE O1.ID = SH.SC#
AND O2.ID = SH.PARENT_SC#