How to build an access control list using query on a relationship fields?

hunghvulast year

2 1

// Users collection
{
  slug: "users"
  ....
  fields: [
    {
      name: "roles"
      type: "relationship"
      relationTo: "user-roles" // User Roles collection
      hasMany: true,
    }
  ]
}

// Articles collection
{
  slug: "articles"
  ....
  fields: [
    {
      name: "whoCanView"
      type: "relationship"
      relationTo: "user-roles"
      hasMany: true,
    }
  ]
}

const query = {
  whoCanView: {
    equals: "user.roles"
  }
}

• Selected Answer
  

  hunghvulast year

  It just came to my mind that I have not updated the solution on this.

  ---

  When a record hasMany relations, the related objects are referenced by ID. For example, if an article can be read by front-desk or management, then the database is represented as followed.

  articleNo1: {
    whoCanRead: [
      0: "123",
      1: "456",
    ]
  }
  
  roles: {
    front-desk: {
      id: "123"
    },
    management: {
      id: "456"
    },
  }
  

  Hence comparison should be based on object.id, not object.otherValue.

  ---

  Each query is considered an object itself, we can construct a dynamic query for many-to-many comparisons. Let's have a sample context here:

  • John has two roles: Front-desk and Management
  • Article can be read by two roles: Tech support and Management
  • The article can be read by John because he has the Management role.

  // read access function
  ...
  const query = {
    or: []
  }
  for (let role of user.roles) {
    query.or.push({
      recordReadAccess: {
       contains: role.id
     }
    }
  }
  // In other words, allow read access if the record contains any of the user roles
  // => Contains "Management" or "Front-desk"
  return query;