There seems to be some re-curring questions about how to manage permissions across all objects in a database. Here's some tools to make this kind of stuff easy. (documentation included in tarball)
Another way is to use pgAdmin's grant wizard (V1.2), which allows easy assignment in a very comfortable way.
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin3/docs/en_US/images/grantwiz.png?rev=HEAD
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster