Index: openacs-4/packages/courses/www/cc-admin/grant-user-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/courses/www/cc-admin/grant-user-list.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/courses/www/cc-admin/grant-user-list.xql	3 Feb 2005 22:41:28 -0000	1.2
+++ openacs-4/packages/courses/www/cc-admin/grant-user-list.xql	4 Feb 2005 23:05:53 -0000	1.3
@@ -13,21 +13,15 @@
 	  select first_names, last_name, user_id as p_user_id
 	  from cc_users where user_id <> :user_id
 	  and (lower(first_names) like '%$user_name%'
-   	  or lower(last_name) like '%$user_name%') and user_id in (
-		select grantee_id from acs_permissions where privilege = 'create' and
-	 	object_id = :cc_package_id
-	  ) order by first_names, last_name
+   	  or lower(last_name) like '%$user_name%') order by first_names, last_name
       </querytext>
 </fullquery>
 
 <fullquery name="select_users_email">      
       <querytext>
 	  select first_names, last_name, user_id as p_user_id
 	  from cc_users where user_id <> :user_id 
-	  and lower(email) like '%$user_email%' and user_id in (
-		select grantee_id from acs_permissions where privilege = 'create' and
-	 	object_id = :cc_package_id
-	  ) order by email
+	  and lower(email) like '%$user_email%' order by email
       </querytext>
 </fullquery>
 
@@ -36,10 +30,7 @@
 	  select first_names, last_name, user_id as p_user_id
 	  from cc_users where user_id <> :user_id 
 	  lower(first_names) like '%$user_name%' or lower(last_name) like '%$user_name%')
-	  and lower(email) like '%$user_email%' and user_id in (
-		select grantee_id from acs_permissions where privilege = 'create' and
-	 	object_id = :cc_package_id
-	  ) order by email
+	  and lower(email) like '%$user_email%' order by email
       </querytext>
 </fullquery>