Index: openacs-4/packages/acs-subsite/www/permissions/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/permissions/index-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/permissions/index-oracle.xql	30 Apr 2001 22:02:48 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/permissions/index-oracle.xql	28 Nov 2001 18:39:39 -0000	1.2
@@ -6,8 +6,8 @@
 <fullquery name="adminable_objects">      
       <querytext>
       
-  select o.object_id, acs_object.name(o.object_id) as name
-  from acs_objects o, acs_object_party_privilege_map map
+  select distinct o.object_id, acs_object.name(o.object_id) as name
+  from acs_objects o, all_object_party_privilege_map map
   where map.object_id = o.object_id
     and map.party_id = :user_id
     and map.privilege = 'admin'