Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public

From: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public
Date: 2017-02-11 21:38:55
Message-ID: 6223968.EFSe4Y2zva@techfox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Adrian,

Op zaterdag 11 februari 2017 13:31:17 schreef Adrian Klaver:
> I see the same thing now.

Glad you do ;)

> That seems to cause a problem

Yeah, I originally ran into this when I noticed that on a restored db a
regular user lost access to tables created by him in the public schema.

Granting 'usage' solves it, but I expect this isn't suppose to happen.

--

Best,

Frank.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2017-02-11 22:06:17 Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public
Previous Message Adrian Klaver 2017-02-11 21:31:17 Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public