SecretIndividual
SecretIndividual

Reputation: 2549

Snowflake schema's not visible after granting database usage

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?

Upvotes: 0

Views: 418

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 176114

Granting explicitly access to PUBLIC schema:

GRANT USAGE ON SCHEMA tst_db.PUBLIC TO ROLE my_role;

Upvotes: 1

Related Questions