Index: openacs-4/packages/assessment/assessment.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/assessment.info,v
diff -u -N -r1.53.2.4 -r1.53.2.5
--- openacs-4/packages/assessment/assessment.info	20 May 2016 20:07:42 -0000	1.53.2.4
+++ openacs-4/packages/assessment/assessment.info	7 Jul 2016 05:18:34 -0000	1.53.2.5
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="2.9.0" url="http://openacs.org/repository/download/apm/assessment-2.9.0.apm">
+    <version name="2.9.1d1" url="http://openacs.org/repository/download/apm/assessment-2.9.1d1.apm">
         <owner url="mailto:eperez@it.uc3m.es">Eduardo Perez Ureta</owner>
         <summary>Assessment package that will replace the surveys
     quizz, complex survey, poll and other data collection packages
@@ -18,10 +18,10 @@
         <maturity>2</maturity>
         <package_instance_name>#assessment.Assessment#</package_instance_name>
 
-        <provides url="assessment" version="2.9.0"/>
+        <provides url="assessment" version="2.9.1d1"/>
         <requires url="acs-content-repository" version="5.9.0"/>
 	<requires url="acs-tcl" version="5.9.1d7"/>
-        <requires url="acs-kernel" version="5.9.0"/>
+        <requires url="acs-kernel" version="5.9.1d11"/>
         <requires url="acs-templating" version="5.9.0"/>
         <requires url="categories" version="1.1.2d3"/>
         <requires url="notifications" version="5.9.0"/>
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 -N -r1.14 -r1.14.2.1
--- openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql	27 Oct 2014 16:40:56 -0000	1.14
+++ openacs-4/packages/assessment/sql/postgresql/assessment-actions-create.sql	7 Jul 2016 05:18:34 -0000	1.14.2.1
@@ -266,8 +266,18 @@
 	new__package_id
 	);
 
+--
+-- The query below can be probably tuned if necessary. Note that also
+-- the old query - accessing was acs_permissions_all - weird (get
+-- permissions while ignoring privileges?). The old query was:
+--
+--      select pretty_name,community_id from dotlrn_communities
+--      where community_id in (select object_id from acs_permissions_all where grantee_id=:user_id)
+--
+--
 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 where community_id in (select object_id from acs_permissions_all where grantee_id=:user_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 from dotlrn_communities where acs_permission.permission_p(community_id, :user_id, ''read'')');
 
 	return v_action_id;
 END; $$ language 'plpgsql';
+
Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql	7 Jul 2016 05:18:34 -0000	1.1.2.1
@@ -0,0 +1,7 @@
+--
+-- Reduce dependency on acs_permissions_all
+--
+UPDATE as_action_params
+SET query = 'select pretty_name,community_id from dotlrn_communities from dotlrn_communities where acs_permission.permission_p(community_id, :user_id, ''read'')'
+WHERE varname = 'community_id';
+