Horace,

How about creating another user 'H', grant select on all of HALIFAX's table to H, create views in the H schema of each HALIFAX table (with the same names) and select from the H views?