Lists: | pgsql-admin |
---|
From: | Tony Capobianco <tcapobianco(at)prospectiv(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | grant select pg 9.0.3 |
Date: | 2012-05-02 19:01:07 |
Message-ID: | 1335985267.1979.7.camel@tony1.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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
From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org>, "Tony Capobianco" <tcapobianco(at)prospectiv(dot)com> |
Subject: | Re: grant select pg 9.0.3 |
Date: | 2012-05-02 19:07:23 |
Message-ID: | 4FA13F9B0200002500047705@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Tony Capobianco <tcapobianco(at)prospectiv(dot)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