[ADMIN] grant select pg 9.0.3

[Tony Capobianco]

I've issued the following statement:

grant select on all tables in schema support to backup;

When I perform a pgdump of the support schema with the backup user it
works fine. If I create a new table within the support schema, pgdump
fails on the support schema. To rectify, I issue the grant statement
again. How can I avoid having to issue the grant each time I create a
new table?

Thanks.
Tony

[Kevin Grittner]

Post by Tony Capobianco
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