大家好,
如果我们将具有行级安全性的表连接到外部表,我们会收到此错误消息。
消息46806,级别16,状态1,行3执行GlobalQuery操作时发生错误:100001;无法生成查询计划。
任何人都知道这里有什么问题吗?
谢谢,
Anca
解决方案
你好,
您是否定义了一个谓词函数来连接两个表?策略是否已使用SCHEMABINDING选项设置为为ON?
docs.microsoft/en-us/sql/relational-databases/安全/行级安全性
希望这会有所帮助。
问候,
Alberto Morillo SQLCoffee
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?
docs.microsoft/en-us/sql/relational-databases/security/row-level-security
Hope this helps.
Regards,
Alberto Morillo SQLCoffee
更多推荐
Azure数据库,连接表与行级安全性和外部表
发布评论