我正在尝试为Snowflake用户赋予查看成本管理异常仪表板的权限，同时不授予过多权限。

我已阅读Snowflake的文档，文档建议如下：

1. 创建一个Snowflake角色。INTERNAL_BILLING_READER
2. 将数据库角色USAGE_VIEWER授予该角色
3. 将对该角色的访问授权给所需的用户。

这仍然会产生一个“无访问权限”的错误，所以我所做的是以下操作

USE DATABASE SNOWFLAKE;
USE SCHEMA ACCOUNT_USAGE;

GRANT DATABASE ROLE USAGE_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT DATABASE ROLE ORGANIZATION_BILLING_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT DATABASE ROLE ORGANIZATION_ACCOUNTS_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT DATABASE ROLE MONITORING_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT DATABASE ROLE ORGANIZATION_USAGE_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT APPLICATION ROLE SNOWFLAKE.APP_USAGE_VIEWER TO ROLE INTERNAL_BILLING_READER;

这仍然不能让处于该角色中的用户看到成本管理异常仪表板。

如果有不涉及授予用户 ACCOUNTADMIN 权限的建议，我将不胜感激。

解决方案

缺少的权限是应用角色 ANOMALY_INSIGHTS_ADMIN

USE DATABASE SNOWFLAKE;
USE SCHEMA ACCOUNT_USAGE;

GRANT DATABASE ROLE USAGE_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT DATABASE ROLE ORGANIZATION_BILLING_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT DATABASE ROLE ORGANIZATION_ACCOUNTS_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT DATABASE ROLE MONITORING_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT DATABASE ROLE ORGANIZATION_USAGE_VIEWER TO ROLE INTERNAL_BILLING_READER;

GRANT APPLICATION ROLE SNOWFLAKE.APP_USAGE_VIEWER TO ROLE INTERNAL_BILLING_READER;
GRANT APPLICATION ROLE SNOWFLAKE.ANOMALY_INSIGHTS_ADMIN TO ROLE INTERNAL_BILLING_READER;

要让异常仪表板可见并不需要预算。