雪花管道访问权限被拒绝 [英] Snowflake Pipe access permission denied

问题描述

使用Snowsql和GUI从用户角色执行管道可以很好地工作，以确认给定角色在管道上没有权限问题。

但是使用相同的角色通过雪管式睡觉接口调用时，遇到下面的错误。

 snowflake.ingest.error.IngestResponseError: Http Error: 403, Vender Code: 390403,

Message: Not authorized to manage the specified object. Pipe access permission denied

我们将非常感谢其中的任何线索。

推荐答案

雪花管道睡觉接口使用的用户需要对分配为DEFAULT_ROLE的管道具有特定权限的角色。 默认角色的分配方式如下：

ALTER USER <user> SET DEFAULT_ROLE=<role>;

其中是用于雪管道操作的角色。

这基本上与RBAC的工作方式有关：

Every active user session has a "current role," also referred to as a primary role. When a session is initiated (e.g. a user connects via JDBC/ODBC or logs in to the Snowflake web interface), the current role is determined based on the following criteria:

- If a role was specified as part of the connection and that role is a role that has already been granted to the connecting user, the specified role becomes the current role.

- If no role was specified and a default role has been set for the connecting user, that role becomes the current role.

- If no role was specified and a default role has not been set for the connecting user, the system role PUBLIC is used.

有关详细信息，请参阅here

具体来说，对于雪管睡觉接口的使用，需要授予该角色以下权限：

查看更多详细信息here

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