
如图,这个需要开什么权限,谢谢
------解决思路----------------------
查看当前USER为guest,执行下面赋权语句即可解决问题
SELECT CURRENT_USER;
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO guest
------解决思路----------------------
GRANT EXECUTE ON sys.xp_prop_oledb_provider TO [UserDomain\Account Name];
ex. GRANT EXECUTE ON sys.xp_prop_oledb_provider TO [AD\MyLogin]