
Answer-first summary for fast verification
Answer: REFERENCE_USAGE
The correct answer is C: REFERENCE_USAGE. According to Snowflake documentation and the community discussion, when sharing a secure view that references objects in other databases, the REFERENCE_USAGE privilege must be granted on each referenced database. This privilege allows the view to reference objects in those databases without exposing the underlying data directly. Option A (READ) is insufficient as it provides data access rather than reference permission. Option B (REFERENCES) is not a valid Snowflake privilege. Option D (USAGE) allows using the database but doesn't specifically enable cross-database references for secure views in data sharing scenarios.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.