VIEW: SYS.KU$_XSPRIV_VIEW

Source

View Text - Preformatted

select '1','0',
  p.priv#,
  p.sc#,
  p.ctime,
  p.mtime,
  p.description,
  (select name from xs$obj o where o.id = p.priv#),
  (select owner from xs$obj o where o.id = p.priv#),
  (cast(multiset(select * from ku$_xsaggpriv_view ap
                        where ap.scid = p.sc# and ap.aggr_privid = p.priv#
                      ) as ku$_xsaggpriv_list_t))
  from xs$priv p

View Text - HTML Formatted

SELECT '1'
, '0'
, P.PRIV#
, P.SC#
, P.CTIME
, P.MTIME
, P.DESCRIPTION
, (SELECT NAME
FROM XS$OBJ O
WHERE O.ID = P.PRIV#)
, (SELECT OWNER
FROM XS$OBJ O
WHERE O.ID = P.PRIV#)
, (CAST(MULTISET(SELECT *
FROM KU$_XSAGGPRIV_VIEW AP
WHERE AP.SCID = P.SC#
AND AP.AGGR_PRIVID = P.PRIV# ) AS KU$_XSAGGPRIV_LIST_T))
FROM XS$PRIV P