且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

无法从链接的SQL Server查询视图

更新时间:2022-11-28 08:39:35

类似权限问题,您是否检查了视图的权限?您的查询没有错.

Looks like a permission issue, have you checked the permissions on the view? There's nothing wrong with your query.

还,您是否检查过该视图查询的表?还要检查表权限.

Also, have you checked what table does that view query on? Check the table permissions as well.

提示:尝试在特定用户上运行视图,如果成功,请尝试使用该特定用户链接服务器.

As a tip: Try to run the view on a specific user and if that's successful try to link the server using that specific user.