SOL-C01 · Question #224
A data consumer subscribes to a listing on the Snowflake Marketplace. After creating the database from the share, they execute the following query: However, they receive an error indicating insufficie
The correct answer is C. The consumer needs to be granted `IMPORTED PRIVILEGES' on the database created from the. When a database is created from a share, the IMPORTED PRIVILEGES' privilege is required to access objects within that database. This privilege is typically granted to a role that the consumer is using. While USAGE on the database and schema are often needed, the specific error de
Question
A data consumer subscribes to a listing on the Snowflake Marketplace. After creating the database from the share, they execute the following query:
However, they receive an error indicating insufficient privileges. Assuming the share was properly configured by the provider, which of the following is the MOST likely reason for this error?
Options
- AThe consumer needs to be explicitly granted ` USAGE privilege on the 'SHARED_DB' database.
- BThe consumer needs to be explicitly granted 'SELECT privilege on the 'SHARED
- CThe consumer needs to be granted `IMPORTED PRIVILEGES' on the database created from the
- DThe consumer needs to be granted
USAGE privilege on thePUBLIC' schema within the - EThe provider revoked the SELECT privilege on the table after the consumer subscribed.
How the community answered
(58 responses)- A2% (1)
- B12% (7)
- C79% (46)
- D3% (2)
- E3% (2)
Explanation
When a database is created from a share, the IMPORTED PRIVILEGES' privilege is required to access objects within that database. This privilege is typically granted to a role that the consumer is using. While USAGE on the database and schema are often needed, the specific error described usually stems from lacking the IMPORTED PRIVILEGES privilege.
Topics
Community Discussion
No community discussion yet for this question.