Snowflake
COF-R02 · Question #316
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
The correct answer is C. SELECT on tables used by the secure view. See the full explanation below for the reasoning.
Question
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
Options
- ACREATE_SHARE on the account
- BSHARE on databases and schemas
- CSELECT on tables used by the secure view
- DREFERENCE_USAGE on databases
How the community answered
(54 responses)- A17% (9)
- B6% (3)
- C74% (40)
- D4% (2)
Community Discussion
No community discussion yet for this question.