SELECT c_proj.name AS "Project", r.target_name AS "User",
CASE WHEN (max(priv.privilege_key) = 0) THEN 'No Access'
WHEN (max(priv.privilege_key) = 2) THEN 'Read'
WHEN (max(priv.privilege_key) = 3) THEN 'Write'
WHEN (max(priv.privilege_key) = 999) THEN 'Full'
END AS "Access"
FROM
(
  SELECT MAX(privilege_key) privilege_key, collection_key, user_key 
  FROM (  SELECT 999 as privilege_key, ELN_collections.section_set_key collection_key, ELN_people.primary_key user_key FROM ELN_collections, ELN_people
 WHERE ELN_people.is_administrator = 1
UNION ALL
SELECT DECODE(ct.is_owner_full_control, 1, 999, 3), c.section_set_key, c.owner_key FROM ELN_collections c, ELN_collection_types ct
WHERE c.collection_type_key = ct.section_set_key
UNION ALL
SELECT privilege_key, ps.target_key, p.primary_key
 FROM ELN_collection_uses cu, ELN_privilege_sources ps, ELN_grantee_sources, ELN_people p
 WHERE cu.collection_key = ps.source_key
 AND cu.grantee_key = ELN_grantee_sources.grantee_key
 AND ELN_grantee_sources.user_key = p.home_collection_key
UNION ALL
SELECT privilege_key, ps.target_key, p.primary_key
 FROM ELN_access_type_grants cu, ELN_privilege_sources ps, ELN_grantee_sources, ELN_people p, ELN_collections c
 WHERE cu.collection_key = ps.source_key
 AND cu.grantee_key = ELN_grantee_sources.grantee_key
 AND ELN_grantee_sources.user_key = p.home_collection_key
 AND c.section_set_key = ps.target_key
 AND c.collection_type_key = cu.collection_type_key
UNION ALL
SELECT privilege_key, ps.target_key, p.primary_key
 FROM ELN_access_state_grants cu, ELN_privilege_sources ps, ELN_grantee_sources, ELN_people p, ELN_collections c
 WHERE cu.collection_key = ps.source_key
 AND cu.grantee_key = ELN_grantee_sources.grantee_key
 AND ELN_grantee_sources.user_key = p.home_collection_key
 AND c.section_set_key = ps.target_key
 AND c.state_key = cu.state_key) ENV_collection_privileges
GROUP BY collection_key, user_key
) priv, 
eln_people p, eln_references r, eln_collections c_user, eln_collection_types ct_user, eln_states s
, eln_collections c_user_group, eln_collection_types ct_user_group
, eln_collections c_proj, eln_collection_types ct_proj
, eln_people pacc
WHERE priv.user_key = p.primary_key
AND p.home_collection_key = r.target_key
AND r.is_active = 1
AND p.home_collection_key = c_user.section_set_key
AND c_user.is_active = 1
AND c_user.collection_type_key = ct_user.section_set_key
AND ct_user.plural_name = 'Users'
AND c_user.state_key = s.primary_key(+)
AND (s.name Is null or s.name = 'Active')
AND r.collection_key = c_user_group.section_set_key
AND c_user_group.collection_type_key = ct_user_group.section_set_key
AND priv.collection_key = c_proj.section_set_key
AND c_proj.is_active = 1
AND c_proj.collection_type_key = ct_proj.section_set_key
AND ct_proj.plural_name = 'HILTI Research Projects'
AND c_proj.collection_type_key <> c_proj.section_set_key
AND lower(r.target_name) like '%user%'
GROUP BY priv.user_key, r.target_name, c_proj.name, priv.privilege_key
HAVING max(priv.privilege_key) > 0
ORDER BY c_proj.name asc, r.target_name asc