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
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?