When an object is created in Snowflake. who owns the object?

The correct answer is C. The current active primary role. In Snowflake, when an object is created, it is owned by the role that is currently active. This active role is the one that is being used to execute the creation command. Ownership implies full control over the object, including the ability to grant and revoke access…

Account Access and Security

Question

Options

AThe public role
BThe user's default role
CThe current active primary role
DThe owner of the parent schema

How the community answered

(29 responses)

A
3% (1)
C
93% (27)
D
3% (1)

Explanation

In Snowflake, when an object is created, it is owned by the role that is currently active. This active role is the one that is being used to execute the creation command. Ownership implies full control over the object, including the ability to grant and revoke access privileges. This is specified in Snowflake's documentation under the topic of Access Control, which states that "the role in use at the time of object creation becomes the owner of the object."

Topics

#Object Ownership#Role-based Access Control (RBAC)#Object Creation#Security Model

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice