SELECT DISTINCT c.portal_name, c.portal_objname, b.rolename, e.descr
  FROM psroleclass b, psprsmperm c, psprsmdefn d, psroledefn e
    WHERE c.portal_objname = d.portal_objname
            AND b.classid = c.portal_permname
            AND b.rolename = e.rolename
            AND (d.portal_uri_seg2 = :1 OR d.portal_objname = :2);

SELECT DISTINCT d.portal_name, d.portal_objname, c.portal_permname, e.classdefndesc
    FROM psprsmperm c, psprsmdefn d, psclassdefn e
     WHERE d.portal_objname = c.portal_objname
            AND d.portal_name = c.portal_name
            AND c.portal_permname = e.classid
            AND (d.portal_uri_seg2 = :1 OR d.portal_objname = :2);

SELECT DISTINCT c.portal_name, c.portal_objname, a.roleuser, e.oprdefndesc
    FROM psroleuser a,
              psroleclass b,
              psprsmperm c,
              psprsmdefn d,
              psoprdefn e
          WHERE c.portal_objname = d.portal_objname
            AND a.rolename = b.rolename
            AND b.classid = c.portal_permname
            AND a.roleuser = e.oprid
            AND (d.portal_uri_seg2 = :1 OR d.portal_objname = :2);