WITH non_updatable_view AS (SELECT table_schema AS view_schema, table_name AS view_name, is_updatable, is_insertable_into
FROM Information_schema.views
WHERE (is_insertable_into='NO' AND is_updatable='NO') 
AND table_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)),
modify_priv AS (SELECT tp.grantee, tp.table_schema AS view_schema, tp.table_name AS view_name, tp.privilege_type AS privilege
FROM information_schema.table_privileges AS tp INNER JOIN information_schema.tables AS t
ON t.table_schema=tp.table_schema AND t.table_name=tp.table_name
WHERE t.table_type='VIEW' AND tp.table_schema NOT IN  (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)
AND tp.privilege_type IN ('INSERT','UPDATE','DELETE') 
AND grantee <> ALL (SELECT viewowner
FROM pg_catalog.pg_views AS pv
WHERE pv.schemaname=tp.table_schema AND pv.viewname=tp.table_name)),
unnecessary_privileges AS (SELECT view_schema, view_name, is_updatable, is_insertable_into, grantee, privilege
FROM non_updatable_view INNER JOIN modify_priv USING (view_schema, view_name))
SELECT format('REVOKE %1$s ON %2$I.%3$I FROM %4$I;', privilege, view_schema, view_name, grantee) AS statements
FROM unnecessary_privileges
ORDER BY grantee, view_schema, view_name;