Re: grant select pg 9.0.3 - Mailing list pgsql-admin

Tony Capobianco <tcapobianco@prospectiv.com> wrote:
> I've issued the following statement:
>
> grant select on all tables in schema support to backup;
>
> How can I avoid having to issue the grant each time I create a new
table?

http://www.postgresql.org/docs/9.0/interactive/sql-alterdefaultprivileges.html

Also, please consider updating to 9.0.7.

http://www.postgresql.org/support/versioning/

-Kevin