oracle8.1.6
select count(*) as number_elements
from rel_segment_party_map map
where map.segment_id = :segment_id
and exists (select 1
from acs_object_party_privilege_map perm
where perm.object_id = map.party_id
and perm.party_id = :user_id
and perm.privilege = 'read')