is this good rls structure?
I have a multi tenant app, each in ever table I have there’s a business_id column
So for every user from each business, I give them a user named like this “business1–admin-johndoe” then I add that user to group “business1”
Then I grant group “business1” access to every row with business_id = business1
Let’s say johndoe is resigning and I need to revoke his access
I just have to revoke him from the role right right?
Is this possible? I am not that familiar with rls
So for every user from each business, I give them a user named like this “business1–admin-johndoe” then I add that user to group “business1”
Then I grant group “business1” access to every row with business_id = business1
Let’s say johndoe is resigning and I need to revoke his access
I just have to revoke him from the role right right?
Is this possible? I am not that familiar with rls
