Index: openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql	26 Nov 2003 22:47:11 -0000	1.11
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql	3 Dec 2003 23:38:27 -0000	1.12
@@ -170,13 +170,14 @@
   and m.rel_id = mr.rel_id
   and m.group_id = (select acs.magic_object_id('registered_users') from dual)
   and m.container_id = m.group_id
+  and m.rel_type = 'membership_rel'
   and mr.member_state = 'approved'
   and u.email_verified_p = 't';
 
 
 -- faster simpler view
 -- does not check for registered user/banned etc
-create view all_users
+create or replace view acs_users_all
 as
 select pa.*, pe.*, u.*
 from  parties pa, persons pe, users u
@@ -200,7 +201,8 @@
 and m.group_id = mo.object_id
 and mo.name = 'registered_users'
 and m.rel_id = mr.rel_id
-and m.container_id = m.group_id;
+and m.container_id = m.group_id
+and m.rel_type = 'membership_rel';
 
 
 -----------------------------------