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.9 -r1.10
--- openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql	30 Sep 2003 12:10:02 -0000	1.9
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql	16 Oct 2003 23:56:01 -0000	1.10
@@ -173,6 +173,16 @@
   and u.email_verified_p = 't';
 
 
+-- faster simpler view
+-- does not check for registered user/banned etc
+create view all_users
+as
+select pa.*, pe.*, u.*
+from  parties pa, persons pe, users u
+where  pa.party_id = pe.person_id
+and pe.person_id = u.user_id;
+
+
 create or replace view cc_users
 as
 select
