Execute As

Question 1

Why use EXECUTE AS?

Answer 1

When you want a user to be able to run a query or stored procedure one time without having to modify the underlying security permanently

Question 2

What is the syntax to EXECUTE AS?

Answer 2

EXEC(UTE) AS USER = ‘USERNAME’

REVERT

Question 3

What if you don’t want the EXECUTE AS statement to end even with a REVERT statement?

Answer 3

EXEC AS USER = ‘USERNAME’ WITH NO REVERT

Question 4

What if you want to specifically revert the EXECUTE AS statement?

Answer 4

Use WITH COOKIE:
DECLARE @COOKIE = VARBINARY(8000)
EXEC AS USER = ‘USERNAME’ WITH COOKIE INTO @COOKIE

Then: REVERT WITH COOKIE = @COOKIE