SQL-Server: Impersonation

Posted by Falcon on Stack Overflow See other posts from Stack Overflow or by Falcon
Published on 2010-05-20T11:07:10Z Indexed on 2010/05/20 11:10 UTC
Read the original article Hit count: 227

Filed under:

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

© Stack Overflow or respective owner

Related posts about sql-server