英文:
Snowflake schema's not visible after granting database usage
问题
运行以下语句：
use role accountadmin;
create role my_role;
grant role my_role to user my_user;
use role SYSADMIN;
create database tst_db;
grant usage on database tst_db to role my_role;
我期望public和information_schema对于角色my_role是可见的，然而它们没有显示出来。
为使它们对于my_role可见，需要哪些授权？
英文:
Running the following statements:
use role accountadmin;
create role my_role;
grant role my_role to user my_user;
use role SYSADMIN;
create database tst_db;
grant usage on database tst_db to role my_role;
I would expect the public and information_schema to be visible to the role my_role, however they do not show up.
What grants are required for them to show up for my_role?
答案1
得分: 1
授予对“PUBLIC”架构的显式访问权限：
GRANT USAGE ON SCHEMA tst_db.PUBLIC TO ROLE my_role;
英文:
Granting explicitly access to PUBLIC schema:
GRANT USAGE ON SCHEMA tst_db.PUBLIC TO ROLE my_role;
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论