SELECT a.project_id, r.one_line as role_name, a.party_id, r.is_lead_p, r.is_observer_p FROM pm_project_assignment a, pm_roles r WHERE a.role_id = r.role_id and project_id = :project_item_id and exists (select 1 from acs_object_party_privilege_map ppm where ppm.object_id = :project_item_id and ppm.privilege = 'read' and ppm.party_id = :user_id) ORDER BY r.role_id