RE: Re: Foreign Key Validation after Reference Table Ownership Change

Поиск
Список
Период
Сортировка
От Battuello, Louis
Тема RE: Re: Foreign Key Validation after Reference Table Ownership Change
Дата
Msg-id 20180321083033.f495bf0537e129b62c3edf58e37f64ff.23347c6e15.mailapi@email02.godaddy.com
обсуждение исходный текст
Ответ на Re: Foreign Key Validation after Reference Table Ownership Change  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Re: Foreign Key Validation after Reference Table Ownership Change
Список pgsql-general
Дерево обсуждения
So, user_2 needs usage on the schema containing its newly owned reference table even though user_1 is performing the insert on a table in the other schema? Interesting. I though the validation was only dependent on user_1's ACL.
 
--------- Original Message ---------
Subject: Re: Foreign Key Validation after Reference Table Ownership Change
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: 3/21/18 11:23 am
To: "Battuello, Louis" <louis.battuello@etasseo.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>

On Wednesday, March 21, 2018, Battuello, Louis <louis.battuello@etasseo.com> wrote:

What permission is being violated at the schema level?

USAGE
 
 
David J.

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

Предыдущее
От: HORDER Phil
Дата:
Сообщение: RE: Foreign Key locking / deadlock issue.... v2
Следующее
От: Alessandro Aste
Дата:
Сообщение: Postgresql 10.3 , query never completes if LIMIT clause is specifiedand paralle processing is on