Sample Header Ad - 728x90

SQL Server impersonation

4 votes
1 answer
5979 views
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