title: Inheriting SQL Server table permission
body: <p>I have a question about permission on the SQL server table. We have two SQL servers (sql-1, sql-2). The actual tables are on the sql-2, the synonyms to the actual tables are on sql-1 and the permission are set on sql-2.</p>
  <p>I was not aware of this setup initially, so I took what I thought was a table on sql-1 at the time and did a INSERT into new table on sql-1, thinking I would inherit all the permissions.  It did not.  My question is when I was doing the Insert, even though the original table resides in sql-2, but when the insert is run on sql-1, would it not take the permission on sql-2 based on the synonym on sql-1 and apply it on the new table on sql-1?</p>
  <p>The solution to my problem was to create the new table on sql-2, create the synonym on sql-1 pointing to sql-2 for the table, then set up the permission on sql-1 in the synonym itself on the new table in sql-2.</p>