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