SnowPro Core Certification — Question 887

What privilege is needed for a Snowflake user to see the definition of a secure view?

Answer options

Correct answer: A

Explanation

To view the definition of a secure view in Snowflake, the user must have the OWNERSHIP privilege, as this grants full control over the object, including the ability to see its definition. The MODIFY privilege allows changes but does not grant visibility of the definition, while CREATE and USAGE do not provide access to view the secure view's details.