Snowflake COF-C03 Question Answer
Which grant will provide a user with access to data that is in a Snowflake share?
GRANT SELECT ON ALL TABLES IN DATABASE < SHARE > TO USER < USER > ;
GRANT READ ON ALL TABLES IN DATABASE < SHARE > TO ROLE < ROLE > ;
GRANT IMPORTED PRIVILEGES ON DATABASE < SHARE > TO ROLE < ROLE > ;
GRANT USE ON DATABASE < SHARE > TO ROLE < ROLE > ;
When a consumer imports a shared database , they must explicitly grant the IMPORTED PRIVILEGES to a role in order to access the shared objects.
TESTED 13 Aug 2026
Copyright © 2014-2026 ACE4Sure. All Rights Reserved