Index: openacs-4/contrib/packages/project-manager/lib/tasks-portlet-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/lib/Attic/tasks-portlet-oracle.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/contrib/packages/project-manager/lib/tasks-portlet-oracle.xql 2 May 2005 08:15:48 -0000 1.1.2.1 +++ openacs-4/contrib/packages/project-manager/lib/tasks-portlet-oracle.xql 4 May 2005 06:13:53 -0000 1.1.2.2 @@ -56,6 +56,10 @@ t.revision_id = i.live_revision and t.item_id = ti.task_id and ti.status = s.status_id + and exists (select 1 from acs_object_party_privilege_map ppm + where ppm.object_id = ti.task_id + and ppm.privilege = 'read' + and ppm.party_id = :user_id) [template::list::orderby_clause -name tasks -orderby]