Answer: When the object is part of a managed access schema

The correct answer is C because in Snowflake, object owners lose their ability to grant privileges on their objects when those objects are part of a managed access schema. Managed access schemas centralize privilege management by restricting grant decisions to only the schema owner (role with OWNERSHIP privilege on the schema) or roles with the MANAGE GRANTS privilege. This is explicitly stated in Snowflake documentation and confirmed by the community discussion, where both comments with upvotes unanimously identify C as the correct answer. Options A and B are incorrect because granting database or account roles to the object owner does not remove their grant privileges. Option D is incorrect because regular schemas allow object owners to retain their grant privileges.

Author: LeetQuiz Editorial Team