title: Is it possible to create read-only synonym in SQL Server?
body: <p>We have 2 different databases DB1 and DB2 with tables in DB2 referring to tables in DB1.</p>
  
  <p>We are looking into the possibility of using SYNONYMS with read-only access in DB2 and use EntityFramework to refer to these SYNONYMS as tables in DB2. </p>
  
  <p>Since currently EF doesn't span across multiple databases, after reading this article (<a href="http://rachel53461.wordpress.com/2011/05/22/tricking-ef-to-span-multiple-databases/" rel="nofollow">http://rachel53461.wordpress.com/2011/05/22/tricking-ef-to-span-multiple-databases/</a>) we are one step ahead, but, we want to only have read-only access to the newly created SYNONYMS.</p>
  
  <p>Any help is greatly appreciated!</p>