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.
