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@xxxxxxxxx>
Date: 3/21/18 11:23 am
To: "Battuello, Louis" <louis.battuello@xxxxxxxxxxx>
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
On Wednesday, March 21, 2018, Battuello, Louis <louis.battuello@xxxxxxxxxxx> wrote:
What permission is being violated at the schema level?
USAGEDavid J.
