Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql 8 Oct 2003 16:59:22 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d9-5.0d13.sql 22 Oct 2003 13:51:51 -0000 1.2 @@ -13,6 +13,13 @@ -- @cvs-id $Id$ -- +-- Should have been added earlier, at least now we save the 4.6.3 - 5.0 upgrade +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 package acs_object