Admin and user roles

im using supabase as my backend, Is there a way to implement roles? (Admin, User, No Access) to give admins the ability to modify or delete all user profiles without having to upgrade to the scale plan?

Hello, there is not really a quick and simple solution for both if you want to have a heavy duty system in place.

As for the handling of the permissions within the app itself you could use workflows on page load which redirect the user based on his role. So for example if you have an admin only section you could redirect non-admin or like non-login users away from it.
That’s simple enough and can be handled by we were with a little bit of effort so it’s a very low hanging fruit if you don’t wanna spending much on the upgrade to the Scale plan.

As for the back-end side of the things, e.g. Supabase set up, I hear this question quite often when people come to consult with me.

The issue is that in order to have a reliable and secure and of course fast system you need to employ some slightly advanced techniques so that it is scalable in the longer run out of records because of how Supabase works since it relies on the RLS policies.

It also really depends a lot on your set up e.g. your app’s functionalities, desired rules and the complexity of your permissions for example usually I discuss these kind of things with the non-technical founders and no-coders who are using Supabase and WeWeb on my one to one consultations. I feel like you could benefit from this and it’s always better to spend a few bucks to save a few hundreds or even in some cases thousands in the long run without talking about all the time saved.