title: In SAAS architecture, how do I handle db schema and MVC user logins for multi-tenants
body: <p>Our requirement is something like this.</p>
  
  <p>We are building a multi-tenant website in ASP.NET MVC, and each customer should be able to create their own users as per predefined user roles.</p>
  
  <p>We are thinking about to create a schema for few tables which would be common for customers. So customer can login to system according to their schema logins and we need not to alter any queries to serve all of them.</p>
  
  <p>We are referring  <a href="http://msdn.microsoft.com/en-us/library/aa479086.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa479086.aspx</a> Shared Database, Separate Schemas.</p>
  
  <p>Can someone suggest on following 
  1. After creating schema how to authorize user against a particular schema 
  2. Is this possible that without any changes in queries db can serve  multi-tenants</p>
  
  <p>Thanks in advance 
  Anil</p>