Index: openacs-4/packages/acs-subsite/www/permissions/perm-user-add-include.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/permissions/perm-user-add-include.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.xql	11 Dec 2003 21:39:56 -0000	1.2
@@ -0,0 +1,30 @@
+<?xml version="1.0"?>
+
+<queryset>
+
+<fullquery name="users_who_dont_have_any_permissions">
+      <querytext>
+
+    select u.user_id,
+           u.first_names || ' ' || u.last_name 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)
+           $page_where_clause
+    order  by upper(first_names), upper(last_name)
+
+      </querytext>
+</fullquery>
+
+<fullquery name="users_who_dont_have_any_permissions_paginator">
+      <querytext>
+
+    select u.user_id
+    from   cc_users u
+    where  u.user_id not in (select grantee_id from acs_permissions_all where object_id = :object_id)
+    order  by upper(first_names), upper(last_name)
+
+      </querytext>
+</fullquery>
+
+</queryset>