Index: openacs-4/packages/chat/www/room-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/chat/www/room-postgresql.xql,v diff -u -r1.2.8.1 -r1.2.8.2 --- openacs-4/packages/chat/www/room-postgresql.xql 2 Jul 2016 10:41:20 -0000 1.2.8.1 +++ openacs-4/packages/chat/www/room-postgresql.xql 2 Jul 2016 10:46:45 -0000 1.2.8.2 @@ -5,9 +5,9 @@ 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 + from persons p, parties pa + where p.person_id = pa.party_id + and acs_permission__permission_p(:room_id, pa.party_id, 'chat_ban') order by p.last_name, p.first_names