Re: Foreign Key Validation after Reference Table Ownership Change

Поиск
Список
Период
Сортировка
От Louis Battuello
Тема Re: Foreign Key Validation after Reference Table Ownership Change
Дата
Msg-id DA4C8A9E-C48D-423E-A967-C9FDEFCE6C8D@etasseo.com
обсуждение исходный текст
Ответ на Foreign Key Validation after Reference Table Ownership Change  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения


On Mar 21, 2018, at 2:36 PM, David G. Johnston  wrote:

And altering an owner of a table to one lacking usage and create permissions on the schema is possible but unadvisible.

David J.


Exactly. The cause of my mistake was changing the REFERENCED table ownership to a role without granting usage on the schema, too. However, with the error occurring when acting as user_1, I wasn’t clear on where the privilege mismatch occurred and which role’s privilege required correction.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Foreign Key Validation after Reference Table Ownership Change
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on