Now that Wappler has added sqlite (and hopefully Couch/Pouch) I’m back to attempt to build an app. Admittedly I’ve forgotten a lot about Wappler, but I’m trying to refresh my knowledge. First up is designing an authorization system (attribute-based or role-based access control).
Mainly, I’m wondering how best to connect it to Server Connect for the portion of the application that lives on the server. Is there a way to make the SC dynamic so it looks at these tables to check that a user is authorized?
My table design will follow something similar to the diagram below where.
- Each user can have one or more groups or roles (admin, user, support team, accounting, agents, etc.).
- Each role will have one or more module permissions (view_user_profile, create_user_profile, view_company, write_company, etc.).
- Each permission will have one or more operations (read, create, write, delete, etc.)
