In the Snowflake access control model, which entity owns an object by default?

The correct answer is D. The role used to create the object. In Snowflake's Role-Based Access Control (RBAC) model, when an object is created, ownership is granted to the active role that executed the CREATE statement - not to the individual user who ran it. This is a fundamental principle: privileges and ownership are assigned to roles…

Account Access and Security

Question

Options

AThe user who created the object
BThe SYSADMIN role
COwnership depends on the type of object
DThe role used to create the object

How the community answered

(38 responses)

A
3% (1)
B
5% (2)
C
3% (1)
D
89% (34)

Explanation

In Snowflake's Role-Based Access Control (RBAC) model, when an object is created, ownership is granted to the active role that executed the CREATE statement - not to the individual user who ran it. This is a fundamental principle: privileges and ownership are assigned to roles, not users. Users exercise permissions through the roles they are granted. This design ensures that when a user leaves or changes roles, object ownership and access control remain stable and tied to the organizational role structure rather than individual accounts.

Topics

#Snowflake Access Control#RBAC#Object Ownership#Roles

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice