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

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 =-----