Can a Schema Owner grant object privileges in a managed access schema?

• A. True
• B. False
• C. Only the PRIMARY could grant
• D. Only in regular schemas

Answer: (A)

In Snowflake, a managed access schema requires explicit grants for object access, but the schema owner holds the authority to distribute those object privileges to roles for the objects inside that schema. Because the schema owner can grant privileges on the objects contained in the schema (as long as they have the right to grant on the object, typically by ownership or an existing GRANT OPTION), the schema owner can indeed grant object-level privileges in a managed access schema. This is why the statement is true.

For example, the schema owner can grant SELECT or INSERT on a table within the managed access schema to a specific role. It’s not limited to a special role like “PRIMARY” and it isn’t restricted only to regular schemas—the ability exists in the managed access model as well.