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
Grant Select on a view not base table when base table is in a different database