VIEW: SYS.KU$_XSACE_VIEW

Source

View Text - Preformatted

select  '1','0',
  c.acl#,
  c.order#,
  c.ace_type,
  c.prin#,
  case when c.prin# > 10000 then
      (select name from xs$obj o where o.id =c.prin#)
  else (select name from user$ where user#=c.prin#)
  end,
  c.prin_type,
  c.prin_invert,
  c.start_date,
  c.end_date,
  (cast(multiset(select * from ku$_xsacepriv_view p
                        where p.aclid = c.acl# and
                              p.ace_order = c.order#
                      ) as ku$_xsacepriv_list_t)),
  (select value(xo) from ku$_xsobj_view xo where xo.id=c.acl#),
  c.ace_flag
  from  xs$ace c
  where bitand(c.ace_flag,2) = 0

View Text - HTML Formatted

SELECT '1'
, '0'
, C.ACL#
, C.ORDER#
, C.ACE_TYPE
, C.PRIN#
, CASE WHEN C.PRIN# > 10000 THEN (SELECT NAME
FROM XS$OBJ O
WHERE O.ID =C.PRIN#) ELSE (SELECT NAME
FROM USER$
WHERE USER#=C.PRIN#) END
, C.PRIN_TYPE
, C.PRIN_INVERT
, C.START_DATE
, C.END_DATE
, (CAST(MULTISET(SELECT *
FROM KU$_XSACEPRIV_VIEW P
WHERE P.ACLID = C.ACL# AND P.ACE_ORDER = C.ORDER# ) AS KU$_XSACEPRIV_LIST_T))
, (SELECT VALUE(XO)
FROM KU$_XSOBJ_VIEW XO
WHERE XO.ID=C.ACL#)
, C.ACE_FLAG
FROM XS$ACE C
WHERE BITAND(C.ACE_FLAG
, 2) = 0