COF-C02 · Question #293
By definition, a secure view is exposed only to users with what privilege?
The correct answer is B. OWNERSHIP. A secure view in Snowflake hides the view's underlying SQL definition (DDL) from all users except those who hold the OWNERSHIP privilege on that view. Unlike a standard view where any user with SELECT privilege can inspect the definition via SHOW VIEWS or GET_DDL(), a secure…
Question
By definition, a secure view is exposed only to users with what privilege?
Options
- AIMPORT SHARE
- BOWNERSHIP
- CREFERENCES
- DUSAGE
How the community answered
(58 responses)- A2% (1)
- B90% (52)
- C2% (1)
- D7% (4)
Explanation
A secure view in Snowflake hides the view's underlying SQL definition (DDL) from all users except those who hold the OWNERSHIP privilege on that view. Unlike a standard view where any user with SELECT privilege can inspect the definition via SHOW VIEWS or GET_DDL(), a secure view protects the internal logic and data from exposure. This is commonly used to enforce data privacy - for example, hiding column masking logic or filtering conditions from end users.
Topics
Community Discussion
No community discussion yet for this question.