Index: openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql 7 Dec 2001 22:46:40 -0000 1.4
+++ openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql 16 Jan 2003 13:40:37 -0000 1.5
@@ -44,27 +44,26 @@
-
- select acs_object__name(context_id)
- from acs_objects
- where object_id = :object_id
+SELECT acs_object__name(context_id) as context_name, context_id, security_inherit_p
+ FROM acs_objects
+ WHERE object_id = :object_id
+
- select object_id as c_object_id,acs_object__name(object_id) as c_name
+ select object_id as c_object_id,acs_object__name(object_id) as c_name, object_type as c_type
from acs_objects o
where context_id = :object_id
and exists (select 1
- from all_object_party_privilege_map
+ from acs_permissions_all
where object_id = o.object_id
- and party_id = :user_id
+ and grantee_id = :user_id
and privilege = 'admin')
-