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.1 -r1.2 --- openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql 22 Apr 2001 16:13:15 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/permissions/one-postgresql.xql 30 Apr 2001 22:02:48 -0000 1.2 @@ -1,15 +1,18 @@ + -postgresql7.1 + postgresql7.1 - - -select acs_object__name(:object_id) from dual - + + + select acs_object__name(:object_id) + - - + + + + select grantee_id, grantee_name, privilege from (select grantee_id, acs_object__name(grantee_id) as grantee_name, privilege, 1 as counter @@ -22,28 +25,37 @@ where object_id = :object_id) dummy group by grantee_id, grantee_name, privilege having sum(counter) > 0 - + + - - + + + + select grantee_id, acs_object__name(grantee_id) as grantee_name, privilege from acs_permissions where object_id = :object_id - + + - - + + + + select acs_object__name(context_id) from acs_objects where object_id = :object_id - + + - - + + + + select object_id as c_object_id,acs_object__name(object_id) as c_name from acs_objects o where context_id = :object_id @@ -52,7 +64,9 @@ where object_id = o.object_id and party_id = :user_id and privilege = 'admin') - + + +