COF-C02 · Question #323
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
The correct answer is C. The schema owner. A managed access schema (created with CREATE SCHEMA ... WITH MANAGED ACCESS) centralizes privilege management. In a regular schema, the role that creates an object owns it and can grant privileges on it to others. In a managed access schema, this changes: object ownership is…
Question
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Options
- AThe database owner
- BThe object owner
- CThe schema owner
- DThe Snowflake user's role
How the community answered
(46 responses)- B2% (1)
- C93% (43)
- D4% (2)
Explanation
A managed access schema (created with CREATE SCHEMA ... WITH MANAGED ACCESS) centralizes privilege management. In a regular schema, the role that creates an object owns it and can grant privileges on it to others. In a managed access schema, this changes: object ownership is held by the schema owner, not by the individual role that created the object. This means only the schema owner (or a role with MANAGE GRANTS) can grant or revoke privileges on objects within the schema. This design prevents object creators from independently sharing data, enforcing tighter governance over who can access objects.
Topics
Community Discussion
No community discussion yet for this question.