Re: No docs for interaction of ON DELETE/UPDATE and permissions

2020-02-25 Thread David Glasser
On Tue, Feb 25, 2020 at 1:54 AM Laurenz Albe wrote: > I am not sure if CREATE TABLE is the perfect place; another place that > would offer ifself is > https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-FK > , > where foreign key constraints are explained. I had found th

No docs for interaction of ON DELETE/UPDATE and permissions

2020-02-24 Thread David Glasser
I was planning to add a new table TA only writable by user A, with a foreign key reference with ON DELETE CASCADE to another table TB only writable by user B. My hope was that user B would still be allowed to delete rows in TB and cause cascading deletions in table TA, and some manual investigatio