Index: openacs-4/packages/acs-subsite/www/permissions/perm-user-add-include-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/permissions/perm-user-add-include-postgresql.xql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-subsite/www/permissions/perm-user-add-include-postgresql.xql 28 Aug 2003 09:41:41 -0000 1.2 @@ -0,0 +1,21 @@ + + + + postgresql7.1 + + + + + select u.user_id, + person__name(u.user_id) as name, + u.email + from cc_users u + where u.user_id not in (select grantee_id from acs_permissions_all where object_id = :object_id) + order by name + + + + + + +