In SAAS architecture, how do I handle db schema and MVC user accounts for multi-users

Question

Our requirement is something like this.

We create a website with several tenants in ASP.NET MVC, and each client should be able to create their own users in accordance with the predefined user roles.

We are going to create a schema for several tables that will be distributed to customers. Thus, the client can enter the system in accordance with their logical inputs of the circuit, and we do not need to change any requests to serve them all.

We refer to http://msdn.microsoft.com/en-us/library/aa479086.aspx General database, separate schemes.

Can anyone suggest the following 1. After creating a user authorization scheme against a specific scheme 2. Is it possible that without any changes in requests, db can serve multi-users.

Thanks in advance Anil

Answer 1

, , , - . , , , , SAAS . . , SAAS, iPhone, . , . , , , , , . , , .

Answer 2

/ SQL Server, , , , .

SQL Query Engine , (). , , (dbo), .

this "", , . , .