SnowPro Core Certification — Question 1003
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Answer options
- A. The database owner
- B. The object owner
- C. The schema owner
- D. The Snowflake user's role
Correct answer: C
Explanation
The correct answer is C, as the schema owner is the one who has the OWNERSHIP privilege over any tables that are added to that schema. The database owner and object owner do not automatically gain privileges over the tables within the managed access schema, and the Snowflake user's role pertains to permission management rather than ownership.