Flashcards in Execute As Deck (4)
Why use EXECUTE AS?
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
What is the syntax to EXECUTE AS?
EXEC(UTE) AS USER = 'USERNAME'
What if you don't want the EXECUTE AS statement to end even with a REVERT statement?
EXEC AS USER = 'USERNAME' WITH NO REVERT