Answer: OWNERSHIP

The OWNERSHIP privilege in Snowflake is a special type of privilege that can only be granted from one role to another role and cannot be revoked. According to Snowflake documentation and the community discussion consensus (with 100% of users selecting C and upvoted comments explaining this behavior), OWNERSHIP is unique in that it must be transferred between roles rather than revoked. The MONITOR and OPERATE privileges are standard privileges that can be both granted and revoked normally. The ALL option is not a specific privilege but rather a way to grant all available privileges on an object.

Author: LeetQuiz Editorial Team