postgresql7.1
select pa.party_id, p.last_name || ', ' || p.first_names as name, pa.email
from persons p, parties pa
where p.person_id = pa.party_id
and pa.party_id in
(select acs_permission.parties_with_object_privilege(:room_id::integer, 'chat_ban'::varchar))
order by p.last_name, p.first_names