Which privilege is needed for a SnowFlake user to see the definition of a secure view?

The correct answer is A. OWNERSHIP. Secure views are specifically designed to hide the underlying query logic from unauthorized users. Even users with SELECT or USAGE on a secure view cannot see its definition. Only the object OWNER (i.e., a role with the OWNERSHIP privilege on the view) can inspect the view's…

Account Access and Security

Question

Options

AOWNERSHIP
BMODIFY
CCREATE
DUSAGE

How the community answered

(49 responses)

A
86% (42)
B
4% (2)
C
2% (1)
D
8% (4)

Explanation

Secure views are specifically designed to hide the underlying query logic from unauthorized users. Even users with SELECT or USAGE on a secure view cannot see its definition. Only the object OWNER (i.e., a role with the OWNERSHIP privilege on the view) can inspect the view's SQL definition using commands like SHOW VIEWS or GET_DDL(). This is the primary distinction between a regular view and a secure view - the definition is hidden from non-owners.

Topics

#Secure Views#Privileges#Access Control#Ownership

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice