Function getUserEntityPermissions

apps/sim/lib/workspaces/permissions/utils.ts:197–232

(
  userId: string,
  entityType: string,
  entityId: string
)

 * @returns Promise<PermissionType | null> - The highest permission the user has for the entity, or null if none
 */
export async function getUserEntityPermissions(
  userId: string,
  entityType: string,
  entityId: string
): Promise<PermissionType | null> {
  if (entityType === 'workspace') {
    const ws = await getWorkspaceWithOwner(entityId)
    if (!ws) {
      return null
    }
    return getEffectiveWorkspacePermission(userId, ws)
  }

  const result = await db
    .select({ permissionType: permissions.permissionType })
    .from(permissions)
    .where(
      and(
        eq(permissions.userId, userId),
        eq(permissions.entityType, entityType),
        eq(permissions.entityId, entityId)
      )
    )

  if (result.length === 0) {
    return null
  }

  const highestPermission = result.reduce((highest, current) => {
    return PERMISSION_RANK[current.permissionType] > PERMISSION_RANK[highest.permissionType]
      ? current
      : highest
  })

  return highestPermission.permissionType
}

/**
 * Retrieves a list of users with their associated permissions for a given workspace.