-- Drop all_users since it masks the oracle all_users view (used by
-- third party admin tools among other things)
drop view all_users;

create or replace view acs_users_all
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;