Index: openacs.org-dev/packages/acs-admin/www/users/one.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-admin/www/users/one.xql,v diff -u -r1.1.1.1 -r1.1.1.2 --- openacs.org-dev/packages/acs-admin/www/users/one.xql 9 Jul 2002 17:34:56 -0000 1.1.1.1 +++ openacs.org-dev/packages/acs-admin/www/users/one.xql 8 Oct 2002 15:46:41 -0000 1.1.1.2 @@ -11,6 +11,15 @@ + + + select privilege + from acs_permissions + where object_id = 0 + and grantee_id = :user_id + and privilege = 'admin' + + @@ -38,10 +47,8 @@ select group_id, rel_id, party_names.party_name as group_name from (select /*+ ORDERED */ DISTINCT rels.rel_id, object_id_one as group_id, object_id_two - from acs_rels rels, all_object_party_privilege_map perm - where perm.object_id = rels.rel_id - and perm.privilege = 'read' - and rels.rel_type = 'membership_rel' + from acs_rels rels + where rels.rel_type = 'membership_rel' and rels.object_id_two = :user_id) r, party_names where r.group_id = party_names.party_id