SQL Server 2008 - Does a trigger fire with the same permissions as the username / username?

Question

Just a quick question:

Say I put an insert trigger in a table in my database.

If data is inserted into this table via login / user "foobar".

Is a trigger executed with the same permissions / permissions as foobar?

Many thanks.

Answer 1

Yes.

You can control this behavior with

EXECUTE AS

create statements, as explained here .

By default for triggers there is

EXECUTE AS CALLER

where do we find

Caller

, . , , , . CALLER - , , , SQL Server 2005.

Answer 2

, ,

WITH EXECUTE AS

http://msdn.microsoft.com/en-us/library/ms188354(v=sql.100).aspx