What is the default access of a securable object until other access is granted?

The correct answer is A. No access. Snowflake follows a deny-by-default access control model. When a securable object (table, view, schema, database, etc.) is created, no role other than the owner (and roles with inherited ownership privileges) has any access to it. Privileges must be explicitly granted using…

Account Access and Security

Question

Options

ANo access
BRead access
CWrite access
DFull access

How the community answered

(31 responses)

A
94% (29)
C
3% (1)
D
3% (1)

Explanation

Snowflake follows a deny-by-default access control model. When a securable object (table, view, schema, database, etc.) is created, no role other than the owner (and roles with inherited ownership privileges) has any access to it. Privileges must be explicitly granted using GRANT statements before other roles or users can interact with the object. This principle of least privilege ensures that data is not accidentally exposed.

Topics

#Default access#Securable objects#Permissions#RBAC

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice