Cannot drop materialized view privileges from user
revoke all privileges on all tables in schema public from "example_user";


This drops privileges from objects in the schema named "public".  It does not drop them from objects in other schemas, such as "example-prod".


  revoke all privileges on "example-prod".view_foo from "example_user";


Works for me.  It still fails due to the other 3 MV, but no longer for that specific one.