VIEW: SYS.KU$_XSROLE_VIEW

Source

View Text - Preformatted

select '1','0',
  (select value(xo) from ku$_xsobj_view xo where p.prin#=xo.id and p.type in (1,2)),
  (cast(multiset(select * from ku$_xsrole_grant_view r
                        where r.role_num = o.id
                      ) as ku$_xsrgrant_list_t))
  from xs$obj o, xs$prin p
  where o.id = p.prin#
  and   bitand(o.flags,1)=0                           /* not Oracle supplied */
  and   p.type in (1,2)

View Text - HTML Formatted

SELECT '1'
, '0'
, (SELECT VALUE(XO)
FROM KU$_XSOBJ_VIEW XO
WHERE P.PRIN#=XO.ID
AND P.TYPE IN (1
, 2))
, (CAST(MULTISET(SELECT *
FROM KU$_XSROLE_GRANT_VIEW R
WHERE R.ROLE_NUM = O.ID ) AS KU$_XSRGRANT_LIST_T))
FROM XS$OBJ O
, XS$PRIN P
WHERE O.ID = P.PRIN#
AND BITAND(O.FLAGS
, 1)=0 /* NOT ORACLE SUPPLIED */
AND P.TYPE IN (1
, 2)