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

Поиск
Список
Период
Сортировка
От Frank van Vugt
Тема Re: [GENERAL] intentional or oversight? pg_dump -c does not restore default priviliges on schema public
Дата
Msg-id 6223968.EFSe4Y2zva@techfox
обсуждение исходный текст
Ответ на Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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.



В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [GENERAL] intentional or oversight? pg_dump -c does not restoredefault priviliges on schema public