Re: Application & Table Merging

Alan Moore wrote:
>
>
> A requirement has now arisen to merge the 4 Instances into one (i.e.
> merge data from 4 table occurences into 1 occurence), on a single UNIX
> platform.
> <snip>
> The data merge is relatively straightforward - BUT !...
>
> A User updating their subset (view) of data also requires 'read only'
> access to the other 3 representative areas IN THE SAME TABLE.
> <snip>

It is legitimate and may be useful to grant select, update [,insert, delete] privilege to the user on the view representing his/her "own" rows, while granting select access only on the views representing others' data. No access to the merged base table needs to be granted. Applications will have to treat the two(or more) views as separate relations ("tables") but, from the way I read your message, this is what must currently happen anyway.

Chrysalis. Received on Wed Mar 05 1997 - 00:00:00 CST