How to get the WINDOWS USER within "EXECUTE AS OWNER"

Question

Is there a function which returns the WINDOWS USER (NOT the database user!) within a procedure which is "EXECUTE AS OWNER" ?

Will ORIGINAL_LOGIN() do this, or does that only return the database user ?

Consider the following situation:

• Windows Users "joe" and "anne" are part of a Active Directory Group, e.g. "PLANNERS"
• The SQL Server Database has "PLANNERS" as Server Login and as Database User.
• There is stored procedure WITH EXECUTE AS OWNER

Now, anne is logging into the SQL Database via Windows Authentification (so she is database user "PLANNERS"), and she calls the procedure. In this procedure, I want to retrieve the Windows User ("anne").

Answer 1

ORIGINAL_LOGIN() is the correct answer.

Just needed it again ;) Thanks @deterministicfail