Re: Desparate Oracle Help...

From: <davide_at_yahoo.com>
Date: 6 Nov 2001 11:50:03 GMT
Message-ID: <9s8ipa$11lgm2$3@ID-18487.news.dfncis.de>

Christopher Burke <craznar_at_hotmail.com> wrote:
> I cannot use VIEWs or SYNONYMS ... they have to be tables when looked at
> from the 'bob' account ... just as they are when 'joe' accesses them.

Well, if you can't use a synonym, the only solution I see, is to create a mirror image of all the tables of Joe into the Bob schema, then set-up a series of triggers that replicate all the modifications performed to Joe's tables into Bob's tables.

But is this worthy ?

Davide Received on Tue Nov 06 2001 - 05:50:03 CST