SQL Server EXECUTE AS and the Ownership Chain Behind a Stored Procedure

<h1> SQL Server EXECUTE AS and the Ownership Chain Behind a Stored Procedure </h1> <p>A stored procedure can give a caller access to tables without granting direct table permissions. This is routine SQL Server design, but the effective authority can be difficult to see from a user's role membership. The module execution context and the ownership chain decide which permissions the engine evaluates.

Read the source →