ResolvedSelf HostedDatabasesWeb

[SOLVED] Appwrite 1.8.1 TablesDB Permissions Issue - 401 on Row Creation (Vue.js 3 Frontend)

Feb 12, 2026, 09:00Last activity 6 months ago

View on Discord

Votes

Replies

Participants

Messages

spahelmuthOriginal post

Web Developer

Feb 12, 2026, 08:34

Hi - I'm migrating a newer VueJS web application from Supabase to Appwrite. I'm looking for an experienced Appwrite Developer to help me solve a permissions issue that I cannot understand?!
Authentication is working correctly, but I'm hitting a 401 "not authorized" error when authenticated users try to create rows using the new TablesDB.createRow() API.
What I don't get is that the row is successfully created in the database, but the API response returns 401, causing the client SDK to throw an exception.

Tech Stack

Self-hosted Appwrite 1.8.1
Appwrite Web SDK v22.0.0
Appwrite Node CLI v13.3.2
Vue.js 3.5 (Options API) + Pinia

I've made a Upwork job post as I'm eager to pay for the help:
https://www.upwork.com/jobs/~022021862142448029565

I hope to do a call with someone experienced who I can show the codebase and hopefully fix the error.

Summary

Appwrite 1.8.1 TablesDB Permissions Issue - User receives a 401 error on row creation despite having appropriate permissions in Vue.js 3 frontend. The issue lies in the permissions check. The solution involves ensuring permissions are correctly set in all related operations.

Axistro

Rank 7: Quantum Computer

Feb 12, 2026, 09:10

You would get better response if you add the details you added on upwork here.
And it might be better to remove the job posting cause you might get scammed by others.

Axistro

Rank 7: Quantum Computer

Feb 12, 2026, 09:11

Btw could you share the whole function instead of just the part that calls appwrite api endpoint?

spahelmuth

Web Developer

Feb 12, 2026, 09:21

That's good advice, thanks @Axistro .
I have an issue when registering a new user, where I want to add some additional details to a 'profiles' table:

async register({ email, password, full_name, line_of_business }) {
try {
await account.create({ userId: ID.unique(), email, password, name: full_name })

  await account.createEmailPasswordSession({ email, password })
  const authenticatedUser = await account.get()

  try {
    await tablesDB.createRow({
      databaseId: 'main',
      tableId: 'profiles',
      rowId: ID.unique(),
      data: {
        user_id: authenticatedUser.$id,
        email,
        full_name,
        line_of_business: line_of_business || null
      },
      permissions: [
        Permission.read(Role.user(authenticatedUser.$id)),
        Permission.update(Role.user(authenticatedUser.$id)),
        Permission.delete(Role.user(authenticatedUser.$id))
      ]
    })
  } catch (profileError) {
    console.error('Failed to create profile document:', profileError)
    // TODO: working but still throwing an error
  }

Currently, the 'profiles' table has the following Permissions:

Any: Create
Guests: Create
Users: Create, Read, Update, Delete

When I register a new user I get:
XHR POST [appwrite host]/v1/tablesdb/main/tables/profiles/rows [HTTP/2 401 32ms]
Failed to create profile document: AppwriteException: The current user is not authorized to perform the requested action.

That said, the Profile is actually added with all the correct values?!

spahelmuth

Web Developer

Feb 12, 2026, 09:22

Similarly, when I create a new 'company':
async createCompany({ name, tax_id, address, company_type }) {
try {
const { user } = useAuthStore()
if (!user) throw new Error('Not authenticated')

  const companyDoc = await tablesDB.createRow({
    databaseId: DB,
    tableId: COMPANIES,
    rowId: ID.unique(),
    data: { name, tax_id, address, company_type },
    permissions: [
      Permission.read(Role.users()),
      Permission.update(Role.user(user.$id)),
      Permission.delete(Role.user(user.$id))
    ]
  })

  await tablesDB.createRow({
    databaseId: DB,
    tableId: COMPANY_USERS,
    rowId: ID.unique(),
    data: {
      user_id: user.$id,
      role: 'owner',
      company: companyDoc.$id
    },
    permissions: [
      Permission.read(Role.users()),
      Permission.update(Role.user(user.$id)),
      Permission.delete(Role.user(user.$id))
    ]
  })

  return { data: normalizeDoc(companyDoc), error: null }
} catch (error) {
  console.error('Create company error:', error)
  return { data: null, error }
}

Where the 'companies' table has the following Permissions:

Users: Create, Read, Update, Delete

I get the following error log in the web console:
XHR POST [appwrite host]/v1/tablesdb/main/tables/companies/rows [HTTP/2 401 107ms]
Create company error: AppwriteException: The current user is not authorized to perform the requested action.

Again - the company is actually created in Appwrite, so I don't get it!?

Axistro

Rank 7: Quantum Computer

Feb 12, 2026, 09:26

I dont see any thing wrong with the code implementation
might be calling some other function which has no permission and you are unable to catch it.

will you be able to share the endpoint and project id and db id?
If you can trust that is.....

spahelmuth

Web Developer

Feb 12, 2026, 12:11

[SOLVED] Appwrite 1.8.1 TablesDB Permissions Issue - 401 on Row Creation (Vue.js 3 Frontend)

[SOLVED] Appwrite 1.8.1 TablesDB Permissions Issue - 401 on Row Creation (Vue.js 3 Frontend)

Need support?_