[dba-SQLServer] Schemas for separation of clients?

[David McAfee]

In one of my systems (SQL Back End), I checked the company that the user ID
belonged to and only returned companies that belonged to the user's
company. If it were a top level user (like a developer) they'd see
everything and on the front end have to select a company.



> ----- Original Message -----
> Hi Gustav:
>
> It initially seem like a good idea but how does a huge and changing number
> of clients get managed...what about web exposure to a mix of online and
> guest accounts get managed?
>
> Jim
>
>