
Explanation:
In Snowflake's access control model, each securable object is owned by a single role. By default, the ownership is granted to the role that was used to create the object. This is explicitly stated in Snowflake documentation and confirmed by the community discussion where all comments unanimously select option D with detailed reasoning. Option A is incorrect because ownership is tied to the role, not the individual user. Option B is incorrect as SYSADMIN is a specific system-defined role, not the default owner for all objects. Option C is misleading because ownership follows the same principle across all object types - it defaults to the creating role.
In the Snowflake access control model, which role is the default owner of a newly created object?
A
The user who created the object
B
The SYSADMIN role
C
Ownership depends on the type of object
D
The role used to create the object
No comments yet.