Re: Foreign Key Validation after Reference Table Ownership Change - Mailing list pgsql-general

From Louis Battuello
Subject Re: Foreign Key Validation after Reference Table Ownership Change
Date
Msg-id 3DCEDEC7-0045-43D8-8D4F-9723F5DC7FEE@etasseo.com
Whole thread Raw
In response to Re: Re: Foreign Key Validation after Reference Table Ownership Change  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Agreed. It would certainly make sense that user_2 have usage on the schema in order to operate against the table owned
byuser_2. I just found it confusing that the discrepancy would cause an issue for user_1, which had all necessary
privilegeson the schema and references on the reference table. Why would an issue with user_2’s ACL manifest itself
witha foreign key validation on insert by user_1 on a table owned by user_1? 


pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: postgresql-10.3 on unbuntu-17.10 - how??
Next
From: Tom Lane
Date:
Subject: Re: Foreign Key Validation after Reference Table Ownership Change