On Sep 23, 2007, at 11:56 PM, Erik Jones wrote:
>
> On Sep 21, 2007, at 6:16 PM, Stefan Arentz wrote:
>
>> Well I'm just toying with an idea. The problem I'm facing is that I
>> would like clients to only see the tuples that they have created and
>> own. I guess I'll just skip direct sql access to the db and write
>> some
>> API on top of it that manages the data. Not a big deal but it
>> complicates things :-)
>>
>
> You could do the same thing with views on those tables. One
> problem with multiple databases is keeping global meta data for all
> of your customers together in a simple way.
Oh, yeah, I forgot to mention separate schemas as well.
Erik Jones
Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com