Re: Help with hosting multiple versions of the same schema (1 per client)

No offense taken...

I think you might have misunderstood the first bit. When I meant came online as meant as I secure a new client. Nothing to do with runtime.

My big reason for not doing the FGAC idea is that I believe I would have an awful time selling that idea to the clients. I'm working in the Jr. Oil & Gas industry where everybody is extremely competitive and secret. I'm not sure that I would want my confidential data being shared in the same set of tables as my competitor.

Are we on different pages?

thx

jack

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:41c622b9$1_2_at_127.0.0.1...
> Comments in-line. And not meant to be rude or disprespectful (Honestly).
>
> Jack Addington wrote:
>
>> Basically I have a small application that I am hosting the database for.
>> As each client comes online I need to create a schema for them.
>
> This is a terrible design ... truly horrible. Have you considered
> keeping all rows, for all clients, in a single table and adding a column
> for schema owner? If so why can't you use it?
>
> You mention FGAC later in your post. I would think that a single schema
> with FGAC would solve the entire problem. If not ... why? I don't see
> anything in your post that would preclude a normalized design.
>
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
> ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
> =-----
Received on Mon Dec 20 2004 - 14:19:00 CST