解决方法
是.
您可以使用控制此行为
EXECUTE AS
create语句的子句,如explained here.
触发器的默认值是
EXECUTE AS CALLER
在哪里找到
CALLER
Specifies the statements inside the module are executed in the context of the
caller of the module. The user executing the module
must have appropriate permissions not only on the module itself,but
also on any database objects that are referenced by the module.
CALLER is the default for all modules except queues,and is the same as sql Server 2005 behavior.
