Build a Multi-Tenant #Supabase Project + #FlutterFlow Role based app

In this video, you'll learn how to build a secure role-based multi-tenant application using #Supabase. We'll use Row-Level Security (RLS) to ensure that regular users can manage their own data, while admins can manage all data within their company. This tutorial covers setting up the database, implementing role-based permissions, creating a scalable multi-tenant design where data is securely isolated by company. I'll also walk you through a simple #FlutterFlow project to demonstrate the concepts. By the end, you'll have a functional app that demonstrates how to handle user roles, permissions and multi-tenancy which can be applied to your own projects.

If you are learning Supabase and FlutterFlow this is a great introduction to these concepts. Once mastered you can extend what you have learnt here with other more complex scenarios.

_____

🔥 Looking for more content? Visit The Digital Pro's NoCode Academy. See link below.

_____

Chapters

00:00 Introduction
00:50 Understanding Multi-Tenant Applications
02:21 Overview of the Video Content
04:40 Setting Up a Superbase Project
05:37 Configuring Authentication and Users
07:06 Creating Database Tables
08:53 Inserting Sample Data
10:54 Associating Users with Companies
12:19 Overview of Row Level Security
13:56 Creating Security Policies
16:08 Explaining Security Policies
19:06 Implementing Security Policies
21:03 Setting Up the Front-End in FlutterFlow
23:21 Sign-In Process and App State Variables
25:44 Navigating to the Homepage
26:02 Overview of the Homepage
27:38 Adding and Deleting To-Dos
29:19 Setting User and Company IDs
30:11 Conditional Visibility Based on User Role
31:19 Testing the Application
32:16 Demonstrating Security Policies in Action
36:47 Conclusion and Final Thoughts

_____

(Support the channel and go ad-free! 😉)

🎉 Your love is much appreciated ... A like to this video is like a High Five!!! Thank you all.

[RomanPittroff]

Amazing—a real-world Supabase implementation with FlutterFlow!

[amiirhamse-jm]

This helped me a lot. I was planning to build a school system where teachers can send assignments to students, so that each student can only see assignments for his or her class.

[DeSofSistemas]

Hi friend, congratulations for this very complete and useful video. I have a question for you: if in my use case I have an Events table, another tickets table, buyers and sellers, should I do the same process for each of them as you do for the tasks (todos) table?

[thenewleadervn]

Thanks for your useful video. I think we need system with many to many relationship between user and company.

[pedrodrig]

Would be great if you can continue this series with: invite user's to a company team by email.

[movie-mark]

Excellent content!!! I had been looking for something like this for a long time. I have a question: When you create filters via API, do these RLS persist? Or does that bypass the RLS?

[PinasPiliNa]

Nice Tutorial, May I ask how to separate data for each company but in each company there are also several branches, Company A might have 2 Branches, COmpany B has 4 branches and so on. Data should also be filtered for each Company and in that company it has 2 or more branches with different users for each branch. Thanks !

[AdityaSingh-htlo]

I have an important question would you answer:-

So, I am making a project that needs Flipkart, ecommerce site to show in web view but the problem is not showing it shows refused to connect.

I try to bypass it but the error remains and I need to implement in my app only not to open it externally.

So kindly tell me is it possible to do it in flutterflow or not .

My final year project needs to be completed and it's a very big thing I have to add. Kindly help./

[jaxontn]

wow lol a whole 39 minutes video for that simple app, at least its explained in detail

[PinasPiliNa]

Sad to know there is no Paypal option to join NoCode academy. It is much safer than to input Card details and SV Code

[Chand_Latif]

This is not the best approach for sure...