Index: openacs-4/packages/assessment/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/index-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/www/index-oracle.xql	23 Jan 2005 18:10:49 -0000	1.1
+++ openacs-4/packages/assessment/www/index-oracle.xql	21 Feb 2005 14:32:56 -0000	1.2
@@ -4,7 +4,7 @@
 
 <fullquery name="asssessment_id_name_definition">
 	<querytext>
-	select cr.item_id as assessment_id, cr.title, cr.description,
+	select cr.item_id as assessment_id, cr.title, cr.description, a.password,
 	       to_char(a.start_time, 'YYYY-MM-DD HH24:MI:SS') as start_time,
 	       to_char(a.end_time, 'YYYY-MM-DD HH24:MI:SS') as end_time,
 	       to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as cur_time
@@ -16,6 +16,7 @@
 		from as_assessment_section_map asm, as_item_section_map ism
 		where asm.assessment_id = a.assessment_id
 		and ism.section_id = asm.section_id)
+	and acs_permission.permission_p (a.assessment_id, :user_id, 'read') = 't'
 	</querytext>
 </fullquery>