In dump file statement which grants permissions on view exists before statement which create view.
--TOC Entry ID 124 (OID 150248) GRANT ALL on my_view to group sales; ... skipped --TOC Entry ID 123 (OID 194103) CREATE VIEW my_view ... ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html