VIEW: SYS.KU$_XSSCLASS_VIEW

Source

View Text - Preformatted

select '1','1',
  sc.sc#,
  sc.ctime,
  sc.mtime,
  sc.description,
  (select value(xo) from ku$_xsobj_view xo where xo.id = sc.sc#),
  (cast(multiset(select * from ku$_xspriv_view p
                        where p.scid = sc.sc#
                      ) as ku$_xspriv_list_t)),
  (cast(multiset(select value(sh) from ku$_xssecclsh_view sh
                        where  sh.scid = sc.sc#
                      ) as ku$_xssecclsh_list_t))
  from xs$seccls sc, xs$obj xo
  where xo.type = 2
    AND sc.sc#= xo.id
    AND bitand(xo.flags,1)=0                          /* not Oracle supplied */
    AND (SYS_CONTEXT('USERENV','CURRENT_USER') IN (xo.owner, 'SYS') OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, SC.SC#
, SC.CTIME
, SC.MTIME
, SC.DESCRIPTION
, (SELECT VALUE(XO)
FROM KU$_XSOBJ_VIEW XO
WHERE XO.ID = SC.SC#)
, (CAST(MULTISET(SELECT *
FROM KU$_XSPRIV_VIEW P
WHERE P.SCID = SC.SC# ) AS KU$_XSPRIV_LIST_T))
, (CAST(MULTISET(SELECT VALUE(SH)
FROM KU$_XSSECCLSH_VIEW SH
WHERE SH.SCID = SC.SC# ) AS KU$_XSSECCLSH_LIST_T))
FROM XS$SECCLS SC
, XS$OBJ XO
WHERE XO.TYPE = 2
AND SC.SC#= XO.ID
AND BITAND(XO.FLAGS
, 1)=0 /* NOT ORACLE SUPPLIED */
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USER') IN (XO.OWNER
, 'SYS') OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))