title: SQL Cross-Schema stored procedure permission issues
body: <p>Given a simplified stored procedure</p>
  
  <pre><code>CREATE OR ALTER PROCEDURE [FooSchema].[Foo]
  AS
  SELECT
      B.*,
      FROM [BarSchema].[Bar] AS B
      WHERE [...]
  </code></pre>
  
  <p>After granting EXEC to a user on the FooSchema, but not on the BarSchema, this stored procedure will fail with the message</p>
  
  <pre><code>The SELECT permission was denied on the object 'Bar',
  </code></pre>
  
  <p>Is there a way to make the user access [FooSchema].[Foo] without exposing [BarSchema].[Bar]'s entire data set as the stored procedure already filters out data relevant to this user.</p>