FK cascade delete permissions Q

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: FK cascade delete permissions Q
Date: 2021-01-29 18:57:05
Message-ID: CAOC+FBVeRVSabhyVGOgR3pfgpGAme6n6FLybwu913AZdR-ROgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a user who created a table B with an FK constraint to table A with
CASCADE DELETE, but receives a permission denied error on A.

It seems odd to me. The FK constraint is not deleting from A, it's ensuring
a delete from B, for which the user has permission.

What am I missing?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2021-01-29 19:12:05 Re: FK cascade delete permissions Q
Previous Message John Scalia 2021-01-28 18:25:11 Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL