AppwriteException: The current user is not authorized to perform the requested action.

Attempting to delete a document from a collection, and having the following error returned:

There are no document-level permissions set. It's my understanding that document level permissions are inherited from collection level permissions, which I've set true for all CRUD operations for the User role.

Document security on all collections is disabled.

The document that I'm trying to delete was created by the same user, and so the user has the ability to create and update the document.
There's another collection that is exactly the same in terms of permissions and configuration, and the user is able to create and delete documents in that collection without any problem.

The problematic collection is one setup with relationship attributes to other collections - and the referenced collections have the same permission configuration - CRUD for all users.

What could be the problem?

Btw, the relationship attribute delete behaviour is set ID to NULL on delete.

changing to cascade for all relationships also doesn't work.