Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] intentional or oversight? pg_dump -c does not restore default priviliges on schema public - Mailing list pgsql-general

From Frank van Vugt
Subject Re: [GENERAL] intentional or oversight? pg_dump -c does not restore default priviliges on schema public
Date
Msg-id 6223968.EFSe4Y2zva@techfox
Whole thread Raw
In response to Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public
Next
From: Stephen Frost
Date:
Subject: Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public