Function checkTableWriteAccess

apps/sim/app/api/table/utils.ts:166–179

* Check if a user has write access to a table. * Write access requires write or admin workspace permission.

(tableId: string, userId: string)

 * Write access requires write or admin workspace permission.
 */
async function checkTableWriteAccess(tableId: string, userId: string): Promise<TableAccessCheck> {
  const table = await getTableById(tableId)

  if (!table) {
    return { hasAccess: false, notFound: true }
  }

  const userPermission = await getUserEntityPermissions(userId, 'workspace', table.workspaceId)
  if (permissionSatisfies(userPermission, 'write')) {
    return { hasAccess: true, table }
  }

  return { hasAccess: false, reason: 'User does not have write access to this table' }
}

/**
 * Access check returning `{ ok, table }` or `{ ok: false, status }`.