grant select pg 9.0.3 - Mailing list pgsql-admin

From Tony Capobianco
Subject grant select pg 9.0.3
Date
Msg-id 1335985267.1979.7.camel@tony1.localdomain
Whole thread Raw
Responses Re: grant select pg 9.0.3
List 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



pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: unexpected EOF on client connection / could not send data to client: Broken pipe
Next
From: "Kevin Grittner"
Date:
Subject: Re: grant select pg 9.0.3