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" <[email protected]> Date: 3/21/18 11:23 am To: "Battuello, Louis" <[email protected]> Cc: "[email protected]" <[email protected]>
On Wednesday, March 21, 2018, Battuello, Louis <[email protected]> wrote: What permission is being violated at the schema level? USAGE https://www.postgresql.org/docs/10/static/sql-grant.html David J.
