
Answer-first summary for fast verification
Answer: The object owner
In a managed access schema, the OWNERSHIP privilege on tables added to the schema remains with the object owner (the role that created the table), not the schema owner. This is clearly documented in Snowflake's official documentation for managed access schemas, which states that while the schema owner manages all privilege grants (including future grants), object owners retain the OWNERSHIP privileges on their objects. The community discussion shows some initial confusion with most users selecting C (schema owner), but the most authoritative comment with documentation references clarifies that object owners keep ownership privileges. The key distinction is that managed access schemas centralize privilege management for granting permissions, but do not transfer object ownership from the creator to the schema owner.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.