Which Snowflake privilege is required on a pipe object to pause or resume pipes?
Which Snowflake privilege is required on a pipe object to pause or resume pipes?
The OPERATE privilege is specifically required to perform actions such as pausing or resuming pipes in Snowflake. Other privileges like READ, SELECT, or USAGE do not grant the necessary permissions to alter the state of a pipe.
A non-owner role with the OPERATE privilege on the pipe can pause or resume a pipe (using ALTER PIPE … SET PIPE_EXECUTION_PAUSED = TRUE | FALSE). SQL operations on schema objects also require the USAGE privilege on the database and schema that contain the object.