Issue: Getting 401 Unauthorized Error When Creating Row with Relationship Despite Having Full User P

Hi team,
I'm encountering a 401 user_unauthorized error when trying to create a row in my projects table, even though I have full user permissions configured for both related tables.
Error Details:
{ "code": 401, "type": "user_unauthorized", "response": "{\"message\":\"The current user is not authorized to perform the requested action.\",\"code\":401,\"type\":\"user_unauthorized\",\"version\":\"1.8.0\"}" }

Code:
await tablesDb.createRow({ databaseId: APPWRITE_DB_ID, tableId: DB_PROJECTS, rowId: ID.unique(), data: { projectName, projectType, projectDescription, projectPriority, projectStatus, company, // This is a relationship field (Many-to-One with companies table) startDate: finalStartDate, dueDate, assignedTo: [${user.$id}], tags, requestedAmountHuf, approvedAmountHuf, progressPercentage: 0, createdBy: user.$id, }, permissions: [Permission.read(Role.user(user.$id))], })

Setup:
Relationship: projects → companies (Many-to-One)
Permissions: Both projects and companies tables have full user access configured
Authentication: User is properly authenticated (using node-appwrite SDK)

What I've tried:

Verified user permissions on both tables
Confirmed the relationship is properly configured
Checked that the company value being passed is a valid document ID

Is there a specific permission requirement for creating rows with relationships that I might be missing? Or could this be related to how relationship permissions are inherited?
Thanks for any guidance!

It looks like the issue isn’t your relationship setup a 401 usually means your user doesn’t have create permissions on the target table itself, or Appwrite is blocking the create action because one of the related fields (like company) requires write access on the connected record too.
I can help you fix this quickly.
Before I jump in, can you confirm one thing:
👉 Does the authenticated user have explicit write permissions on the companies table, not just read?
Once I know that, I can guide you straight to the exact permission causing the block.

Hi!
the user have C,R,U,D (All) permissions for whole 2 table. :/

not explicit, it has "label" permission.

Thanks for the update!
If both tables only use label-based permissions instead of explicit user permissions, that’s most likely where the issue is coming from. Appwrite can be very strict when creating rows that reference another table — even with full CRUD labels, the SDK may still require a direct permission for the authenticated user on the related record.
This is something I can diagnose and fix quickly by checking how the labels, roles, and relationship field permissions are interacting.
If you’d like, feel free to message me I can take a closer look at your setup and get this resolved fast.

SOLVED

The problem was the next.
When i write relation, in response i got back whole object.

And there is the problem.

Project -> Company -> CompanyContacts

If the user no have read permission for CompanyContacts table, we got the error message.