Which privilege must be granted by one role to another role, and cannot be revoked?
Which privilege must be granted by one role to another role, and cannot be revoked?
The privilege that must be granted by one role to another role and cannot be revoked is OWNERSHIP. When ownership is transferred, it ensures that the receiving role has full control, and this action is permanent. Other privileges like MONITOR, OPERATE, or ALL can be granted and revoked, but OWNERSHIP is unique in its permanence once conferred.
C https://docs.snowflake.com/en/sql-reference/sql/grant-ownership
OWNERSHIP is a special type of privilege that can only be granted from one role to another role; it cannot be revoked
cccccccccc
C OWNERSHIP cannot be revoked