VIEW: SYS.KU$_XSPOLICY_VIEW

Source

View Text - Preformatted

select '1','0',
  p.xdsid#,
  p.ctime,
  p.mtime,
  p.description,
  (select value(xo) from ku$_xsobj_view xo where p.xdsid#=xo.id),
  (cast(multiset(select value(ia)
                 from ku$_xsinstset_view ia
                 where ia.xdsid= p.xdsid#)
                 as ku$_xsinstset_list_t)),
  (cast(multiset(select  value(a)
                 from ku$_xsattrsec_view a
                 where a.xdsid=p.xdsid#
                 order by a.priv_num)
                 as ku$_xsattrsec_list_t)),
  (select value(o) from ku$_xsolap_policy_view o
                  where o.name = (select name from xs$obj o where p.xdsid#=o.id) AND
                        o.owner_name = (select owner from xs$obj o where p.xdsid#=o.id)),
  (select value(r) from ku$_xsrls_policy_view r
                  where  r.pfschma= (select xo.owner from ku$_xsobj_view xo where xo.id=p.xdsid#) and
                         r.name = (select xo.name from ku$_xsobj_view xo where xo.id=p.xdsid#))
  from xs$dsec p, xs$obj xo
  where xo.type = 5
    AND p.xdsid# = 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'
, '0'
, P.XDSID#
, P.CTIME
, P.MTIME
, P.DESCRIPTION
, (SELECT VALUE(XO)
FROM KU$_XSOBJ_VIEW XO
WHERE P.XDSID#=XO.ID)
, (CAST(MULTISET(SELECT VALUE(IA)
FROM KU$_XSINSTSET_VIEW IA
WHERE IA.XDSID= P.XDSID#) AS KU$_XSINSTSET_LIST_T))
, (CAST(MULTISET(SELECT VALUE(A)
FROM KU$_XSATTRSEC_VIEW A
WHERE A.XDSID=P.XDSID# ORDER BY A.PRIV_NUM) AS KU$_XSATTRSEC_LIST_T))
, (SELECT VALUE(O)
FROM KU$_XSOLAP_POLICY_VIEW O
WHERE O.NAME = (SELECT NAME
FROM XS$OBJ O
WHERE P.XDSID#=O.ID) AND O.OWNER_NAME = (SELECT OWNER
FROM XS$OBJ O
WHERE P.XDSID#=O.ID))
, (SELECT VALUE(R)
FROM KU$_XSRLS_POLICY_VIEW R
WHERE R.PFSCHMA= (SELECT XO.OWNER
FROM KU$_XSOBJ_VIEW XO
WHERE XO.ID=P.XDSID#) AND R.NAME = (SELECT XO.NAME
FROM KU$_XSOBJ_VIEW XO
WHERE XO.ID=P.XDSID#))
FROM XS$DSEC P
, XS$OBJ XO
WHERE XO.TYPE = 5
AND P.XDSID# = 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' ))