
Answer-first summary for fast verification
Answer: OWNERSHIP
The correct answer is OWNERSHIP because secure view definitions are only exposed to users who have been granted the role that owns the view. This is the primary and most direct way to access secure view definitions. While the community discussion mentions that users with IMPORTED PRIVILEGES on the SNOWFLAKE database, ACCOUNTADMIN role, or SNOWFLAKE.OBJECT_VIEWER database role can also see secure view definitions via the VIEWS Account Usage view, these are alternative methods rather than the specific privilege being asked about. The question specifically asks for the privilege needed, and OWNERSHIP is the fundamental privilege that grants this access. Other privileges like MODIFY, CREATE, and USAGE do not provide the ability to view secure view definitions.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.