Index: openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql	13 Mar 2005 22:08:45 -0000	1.7
+++ openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql	9 Jun 2005 19:19:47 -0000	1.8
@@ -230,7 +230,7 @@
 	);
 
 v_parameter_id:= nextval(''as_action_params_parameter_id'');
-insert into as_action_params (parameter_id, action_id,type, varname, description,query) values (v_parameter_id,v_action_id,''q'',''community_id'',''Community to add the user'', ''select pretty_name,community_id from dotlrn_communities'');
+insert into as_action_params (parameter_id, action_id,type, varname, description,query) values (v_parameter_id,v_action_id,''q'',''community_id'',''Community to add the user'', ''select pretty_name,community_id from dotlrn_communities where community_id in (select object_id from acs_permissions_all where grantee_id=:user_id)'');
 
 	return v_action_id;
 end;' language 'plpgsql';
