sql server SYNONYM跨库查询权限
环境:WIN SERVER 2008 R2 + SQL SERVER 2008 R2
WIN SERVER 2003 +SQL SERVER 2005
数据库A:
表A
数据库B:
用户:C
同义词 SYNONYM_A
CREATE SYNONYM [dbo].[SYNONYM_A] FOR A.DBO.表A
存储过程B:
CREATE PROC B
WITH RUN AS SA
AS
SELECT *
FROM SYNONYM_A
将存储过程B的执行权限给C。
问题:当C执行存储过程B时,报SA在上下文中没有访问数据库A的权限。如何解决?