VIEW: SYS.KU$_XSROLESET_VIEW

Source

View Text - Preformatted

select '1','0',
  rs.rsid#,
  rs.ctime,
  rs.mtime,
  rs.description,
  (select value(xo) from ku$_xsobj_view xo where xo.id = rs.rsid#),
  (cast(multiset(select value(o) from ku$_xsobj_view o
                        where   o.id in (select role# from xs$roleset_roles rsr
                                               where rsr.rsid#=rs.rsid#)
                      ) as ku$_xsobj_list_t))
  from xs$roleset rs, xs$obj xo
  where rs.rsid# = xo.id
    and bitand(xo.flags,1) = 0                        /* not Oracle supplied */

View Text - HTML Formatted

SELECT '1'
, '0'
, RS.RSID#
, RS.CTIME
, RS.MTIME
, RS.DESCRIPTION
, (SELECT VALUE(XO)
FROM KU$_XSOBJ_VIEW XO
WHERE XO.ID = RS.RSID#)
, (CAST(MULTISET(SELECT VALUE(O)
FROM KU$_XSOBJ_VIEW O
WHERE O.ID IN (SELECT ROLE#
FROM XS$ROLESET_ROLES RSR
WHERE RSR.RSID#=RS.RSID#) ) AS KU$_XSOBJ_LIST_T))
FROM XS$ROLESET RS
, XS$OBJ XO
WHERE RS.RSID# = XO.ID
AND BITAND(XO.FLAGS
, 1) = 0 /* NOT ORACLE SUPPLIED */