Execute Trigger as Login

Question

Is it possible to impersonate a login when running a trigger?

I able able to run execute as 'username' but not execute as login='username'

I can usee execute as as such

with EXECUTE AS  login='smr'
  select top 9 * from Phonelist.dbo.po
REVERT

I want to put this in a trigger by I get a syntax error. My trigger loos like

ALTER TRIGGER triggername ON TableName
with execute as login = "USER_A" 
AFTER INSERT AS 
BEGIN
DECLARE @var varchar(20)SELECT TOP 1 @var = columnname FROM DATABASE_B.dbo.TABLE_B
END

Which version, and can you post the entire statement in which you use an `EXECUTE AS` clause? I don't know of any syntax that includes `login=...` — squillman, Oct 06 '14 at 19:50

score 2 · Answer 1 · answered Oct 06 '14 at 20:18

2

The syntax you're looking for on the ALTER TRIGGER command is:

ALTER TRIGGER ON tableName WITH EXECUTE AS 'loginName'

answered Oct 06 '14 at 20:18

Evan Anderson

141,071
19
191
328

Execute Trigger as Login

1 Answers1