Re: grant select pg 9.0.3

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
Thread:
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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mitesh Shah 2012-05-02 19:55:58 pg_dump: aborting because of server version mismatch
Previous Message Tony Capobianco 2012-05-02 19:01:07 grant select pg 9.0.3