asked
Auditing Security when using execute as
If you create a stored procedure with the execute as clause - can you somehow still record the username of actual user running the stored procedure?
Yes. SYSTEM_USER will tell you the current context, but ORIGINAL_LOGIN() should be able to tell you the base user account. ![ORIGINAL_LOGIN() shows that I'm still the one running this query, even though SYSTEM_USER tells me that I am executing as Reader.][1] [1]: /upfiles/OriginalLogin.png
