[ADMIN] grant select pg 9.0.3

2012-05-02 Thread 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



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] grant select pg 9.0.3

2012-05-02 Thread Kevin Grittner 
Tony Capobianco tcapobia...@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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin