对对象ADF管道的SELECT权限被拒绝 [英] The SELECT permission was denied on the object ADF Pipeline

问题描述

大家好，

我的ADF遇到问题.我想将表数据从源加载到Datalake

I am facing an issue with my ADF. I want to load table data from source to Datalake

我在源中有10个表，所有表的架构为< g class ="gr_gr_10 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling" data-gr-id ＝"10". id ="10" dbo .

I am having 10 tables in the source, all tables schema is <g class="gr_ gr_10 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling" data-gr-id="10" id="10">dbo</g>.

但是以某种方式我只能加载4个表，而对于其他6个表，它却给了我类似下面的错误

but somehow I am able to load only 4 tables, for others 6 table, it is giving me error like below

有人可以让我知道管道的问题是什么或者我做错了什么

Can someone please let me know what is the issue with a pipeline or something doing wrong by me

感谢& amp;问候，Vipin jha MCP

Thankx &amp; regards, Vipin jha MCP

推荐答案

' ' ， 架构'dbo'.

The SELECT permission was denied on the object 'ABX_TBL', database 
'ADVENTURE', schema 'dbo'.

从此消息中，您的帐户您的SQL链接服务中的用户没有访问此表的权限.您可以尝试使用本地SQL客户端 通过使用此帐户，查看它是否可访问.

from this message, your account in your SQL linked service doesn't have permission to access this table. you can try your local SQL client by using this account, see if it is accessible.

这篇关于对对象ADF管道的SELECT权限被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！