SQL-Server: Impersonation

Question

Hello,

is there any way to make a certain session execute all commands as a certain user? I cannot use the execute as clause because it mustn't be hardcoded.

I need something along the lines of this pseudocode:

ALTER SESSION sessionid SET EXECUTING_USER=someuser

Answer 1

EXECUTE AS can accept variables (in 2008 at least) so you don't have to hardcode the name to use it.

DECLARE @username sysname = 'foobar'

EXECUTE AS USER = @username

SELECT SESSION_USER