雪花查询授予角色

Question

我将所有表授予了一个角色：

grant select on all tables in               schema WORKING to role PROD_WORKING_SR;
grant select on all views  in               schema WORKING to role PROD_WORKING_SR;
grant select on future tables in            schema WORKING to role PROD_WORKING_SR;
grant select on future views  in            schema WORKING to role PROD_WORKING_SR;

但是当我尝试使用命令验证授权时

show grants to role PROD_WORKING_SR

我一无所获。有人能帮我查询一下，我可以像上面那样提取授予角色的所有权限吗。

感谢你的帮助！！！

Answer 1

您需要为数据库和架构的角色授予USAGE权限

你可以使用

grant usage on database <your db name> to role PROD_WORKING_SR;
grant usage on schema WORKING to role PROD_WORKING_SR;