Snowpipe: Disable pipe role drop prevention (Preview)¶

The behavior when dropping a role that holds OWNERSHIP on a PIPE object is changing as follows:

Before the change:

Dropping a role that holds the OWNERSHIP privilege on a PIPE object fails. This restriction was originally intended to prevent privilege escalation when a pipe’s owner role is dropped. Pipes are the only object type with this restriction.

After the change:

Dropping a role that holds the OWNERSHIP privilege on a PIPE object succeeds. This aligns the behavior of pipes with all other Snowflake object types, including owner’s rights objects such as stored procedures and services.

This change is being made to ensure consistency across object types and to enable automation workflows that drop roles.

Ref: 2216