Snowflake Inc.
(an account-, database-, or schema-level parameter set with ALTER) to narrow the role scope the server advertises, and restrict ALLOWED_ROLES_LIST on the integration to enforce which roles a user can consent to (PRE_AUTHORIZED_ROLES_LIST does the opposite: it lists roles that skip the consent step).
If you set OAUTH_AUTHORIZATION_SERVER to issuer-lock an MCP scope to an external IdP (Pattern 2), Snowflake OAuth tokens (Pattern 1) are rejected for MCP servers in that scope and do not fall back.