title: How to create users with limited read-only rights in Multitenant Data warehouse with one schema per tenant with views only in MS SQl server 2014
body: <p>I want to create a data warehouse where data for all tenants are stored in tables under dbo schema. and now I want to create separate schema per tenant so I can create separate users. along with I wish to create views in these tenant specific schema for relevant data only. users created for these schema will have read-only rights on these schemas. Now problem occurs when I create user and grant right on their specific schema but not on dbo. as views created in any schema are reading data from dbo internaly so sql statements gets failed saying that user doesn't have permission on dbo schema. If I grant permission on dbo schema then user gets access to all data.</p>
  
  <p>Can I somehow make it possible to keep data stored centralized and users created for any schema with specific access.</p>