Azure数据库,连接表与行级安全性和外部表 [英] Azure database, join betwen table with row level security and external table
问题描述
大家好,
如果我们将具有行级安全性的表连接到外部表,我们会收到此错误消息。
消息46806,级别16,状态1,行3执行GlobalQuery操作时发生错误:100001;无法生成查询计划。
任何人都知道这里有什么问题吗?
谢谢,
Anca
你好,
您是否定义了一个谓词函数来连接两个表?策略是否已使用SCHEMABINDING选项设置为
为ON?
https://docs.microsoft.com/en-us/sql/relational-databases/安全/行级安全性
希望这会有所帮助。
问候,
Alberto Morillo
SQLCoffee.com 跨度>
Hi guys,
we get this error message if we join a table with row level security to an external table.
Msg 46806, Level 16, State 1, Line 3 An error occurred while executing GlobalQuery operation: 100001;Failed to generate query plan.
Anyone any idea what could be wrong here?
Thank you,
Anca
Hello,
Have you define a predicate function to join both tables? Has the policy been created with the SCHEMABINDING option set to ON?
https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security
Hope this helps.
Regards,Alberto Morillo
SQLCoffee.com
这篇关于Azure数据库,连接表与行级安全性和外部表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!