title: Cross db permission issue
body: <p>I have 3 databases on the same SQL Server 2012:<br>
   - erpCountry1<br>
   - erpCountry2<br>
   - erpWeb  </p>
  
  <p>erpWeb database was built to allow a special user (webUser) to read some data from outside. It is mostly a few views like this (simplified version):  </p>
  
  <pre><code>create view erpWeb.dbo.vwClients
  as
  SELECT 'XX' as Region, IdClient, Nom, Adress
      FROM erpCountry1.dbo.Clients
  UNION ALL
  SELECT 'YY' as Region, IdClient, Nom, Adress
      FROM erpCountry2.dbo.Clients
  </code></pre>
  
  <p>Currently the user webUser must be mapped to <code>erpCountry1</code> and <code>erpCountry2</code> databases, otherwise view <code>erpWeb.dbo.vwClients</code> does not work for him.  </p>
  
  <p>My question is: what should I do to allow webUser to see the result of vwClients WITHOUT mapping webUser as <code>datareader</code> for erpCountry1 and erpCountry2 ? (since this allows webUser to see all data of those databases)</p>
  
  <p><strong>Edit</strong>: in Access, you can define a query to run with owner's permissions (instead of user's). Isn't there anything equivalent in SQL Server ?</p>