oracle8.1.6 select party_id, acs_object.name(party_id) as name from acs_object_party_privilege_map where object_id = :room_id and privilege = 'chat_room_moderate' select distinct party_id, acs_object.name(party_id) as name from acs_object_party_privilege_map where object_id = :room_id and (privilege = 'chat_read' or privilege = 'chat_write') select m.party_id, p.last_name || ', ' || p.first_names as name, pa.email from acs_object_party_privilege_map m, persons p, parties pa where m.party_id = p.person_id and m.object_id = :room_id and m.privilege = 'chat_ban' and p.person_id = pa.party_id order by p.last_name, p.first_names