What is the MINIMUM permission needed to access a file URL from an external stage?

The correct answer is D. USAGE. To access a file URL from an external stage in Snowflake, the minimum permission required is USAGE on the stage object. USAGE permission allows a user to reference the stage in SQL commands, necessary for actions like listing files or loading data from the stage, but does not…

Account Access and Security

Question

Options

AMODIFY
BREAD
CSELECT
DUSAGE

How the community answered

(50 responses)

A
2% (1)
B
4% (2)
C
2% (1)
D
92% (46)

Explanation

To access a file URL from an external stage in Snowflake, the minimum permission required is USAGE on the stage object. USAGE permission allows a user to reference the stage in SQL commands, necessary for actions like listing files or loading data from the stage, but does not permit the user to alter or drop the stage.

Topics

#Permissions#Stages#External Stages#Access Control

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice