Index: openacs-4/packages/acs-subsite/www/permissions/one-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/permissions/one-oracle.xql,v diff -u -r1.3.4.1 -r1.3.4.2 --- openacs-4/packages/acs-subsite/www/permissions/one-oracle.xql 7 Dec 2002 16:06:29 -0000 1.3.4.1 +++ openacs-4/packages/acs-subsite/www/permissions/one-oracle.xql 2 Aug 2003 05:37:46 -0000 1.3.4.2 @@ -22,7 +22,7 @@ select grantee_id, acs_object.name(grantee_id) as grantee_name, privilege, -1 as counter from acs_permissions - where object_id = :object_id) + where object_id = :object_id ) group by grantee_id, grantee_name, privilege having sum(counter) > 0 @@ -37,6 +37,7 @@ privilege from acs_permissions where object_id = :object_id + $extra_where_clause