Answer: REVOKE ROLE

The REVOKE ROLE command is specifically designed to remove a role from another role or a user in Snowflake, as shown in the provided SQL syntax: REVOKE ROLE <role_name> FROM { USER <user_name> | ROLE <parent_role_name> }. This directly matches the question's requirement. ALTER ROLE (A) is used to modify role properties, not remove roles from users or other roles. USE ROLE (C) and USE SECONDARY ROLES (D) are for setting active roles in a session, not for role removal. The community discussion unanimously supports B with 100% agreement and references to Snowflake documentation, confirming it as the correct choice.

Author: LeetQuiz Editorial Team