I'm using postgres 9.1 on ubuntu and need to accomplish this. I could itterate over all the known databases in a shell script and issue the commands to accomplish this, but that doesn't cover future databases and adds overhead to build times in our CI server.

Does any know a way to create a super or regular user that has read-only and connect access to all existing and future databases and tables?