Re: Foreign Key Validation after Reference Table Ownership Change

From: Louis Battuello <louis(dot)battuello(at)etasseo(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Foreign Key Validation after Reference Table Ownership Change
Date: 2018-03-21 17:18:58
Message-ID: 3DCEDEC7-0045-43D8-8D4F-9723F5DC7FEE@etasseo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Agreed. It would certainly make sense that user_2 have usage on the schema in order to operate against the table owned by user_2. I just found it confusing that the discrepancy would cause an issue for user_1, which had all necessary privileges on the schema and references on the reference table. Why would an issue with user_2’s ACL manifest itself with a foreign key validation on insert by user_1 on a table owned by user_1?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-03-21 17:39:16 Re: Foreign Key Validation after Reference Table Ownership Change
Previous Message Vincenzo Romano 2018-03-21 17:12:43 Re: postgresql-10.3 on unbuntu-17.10 - how??