VIEW: SYS.KU$_XSACLPARAM_VIEW

Source

View Text - Preformatted

select '1','0',
  ap.xdsid#,
  (select name from xs$obj where id = ap.xdsid#),
  (select owner from xs$obj where id = ap.xdsid#),
  ap.acl#,
  ap.pname,
  ap.pvalue1,
  ap.pvalue2,
  (select type from xs$policy_param p where p.xdsid#=ap.xdsid# and p.pname=ap.pname)
  from xs$acl_param ap

View Text - HTML Formatted

SELECT '1'
, '0'
, AP.XDSID#
, (SELECT NAME
FROM XS$OBJ
WHERE ID = AP.XDSID#)
, (SELECT OWNER
FROM XS$OBJ
WHERE ID = AP.XDSID#)
, AP.ACL#
, AP.PNAME
, AP.PVALUE1
, AP.PVALUE2
, (SELECT TYPE
FROM XS$POLICY_PARAM P
WHERE P.XDSID#=AP.XDSID#
AND P.PNAME=AP.PNAME)
FROM XS$ACL_PARAM AP