From: Frank van Vugt <ftm.van.vugt@foxi.nl>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@postgresql.org
Subject: Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public
Date: Sat, 11 Feb 2017 22:38:55 +0100
Message-ID: <6223968.EFSe4Y2zva@techfox> (raw)
In-Reply-To: <306a4b5b-4586-14e1-ff82-7ac509e859f1@aklaver.com>
References: <3534542.o3cNaKiDID@techfox>
<2062187.tvUsDYMTVR@techfox>
<306a4b5b-4586-14e1-ff82-7ac509e859f1@aklaver.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: ftm.van.vugt@foxi.nl, adrian.klaver@aklaver.com
Subject: Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public
In-Reply-To: <6223968.EFSe4Y2zva@techfox>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox