[dba-SQLServer] Schemas for separation of clients?

[Jim Lawrence]

That sounds reasonable...there would only be a limited range of type of users...then the scenario could work.

Jim

----- Original Message -----
From: "David McAfee" <davidmcafee at gmail.com>
To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com>
Sent: Sunday, March 29, 2015 7:19:33 PM
Subject: Re: [dba-SQLServer] Schemas for separation of clients?

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
>
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com