This question is about impersonation in Microsoft SQL Server. I want to know that if I have impersonation permissions on a specific login then I can easily impersonate that login whenever I want and I do not need to have a stored procedure with
EXECUTE AS OWNER
? If that is so then what is the purpose of a stored procedure with EXECUTE AS
?
Asked by Zeshan Mujtaba
(43 rep)
May 1, 2019, 03:16 PM
Last activity: May 2, 2019, 09:28 PM
Last activity: May 2, 2019, 09:28 PM