When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
In a managed access schema, the schema owner is responsible for managing all privilege grants, including future grants, on objects within the schema. While object owners retain ownership privileges on their objects, the schema owner has overarching control over privilege grants. Therefore, the schema owner holds the ultimate OWNERSHIP privilege of any tables added to the schema.
C https://docs.snowflake.com/en/sql-reference/sql/create-versioned-schema#:~:text=In%20managed%20schemas%2C%20the%20schema%20owner%20manages%20all%20privilege%20grants%2C%20including%20future%20grants%2C%20on%20objects%20in%20the%20schema.%20Object%20owners%20retain%20the%20OWNERSHIP%20privileges%20on%20the%20objects%2C%20however%2C%20only%20the%20schema%20owner%20can%20manage%20privilege%20grants%20on%20the%20objects.
c is correct
ccccccc
C Schema owner