I have agents and managers as users. Sales funnel Data is in big tables. I can’t use google sheets as i don’t want to pay for updates. RLS is applied via e-mail so each agent see’s their own data.
Managers need to see all the data. Currently everytime a new manager joins, i need to add a new ‘manager access’ column bearing his name manually in each data table(there are multiple data tables), have it populated with that new manager’s e-mail for all the rows of data for each table and then use it for RLS in addition to all previous columns. This is not scalable at all.
This seems to be a very essential core feature because there could be need of various hierarchy based views (like CEO, VP, Manager, Agent and so on) that could need RLS and not just filter views and it seems its impossible in glide big tables (i’ve seen the documentation and solutions are : Either Use google sheet/airtable for array e-mails or each row owner needs to have their own column incase of glide tables).
Please Help @NoCodeAndy
Thank you
AK
1 Like
Excuse my ignorance, what is RLS in this context?
The solution here should be to use Roles as Row Owners. That is, give each of your Managers a “Manager” role in their User Profile row, then have a single “Manager Owner” Row Owner column in each of your Data Tables, populated with the word “Manager”. Then whenever you add a new manager, they will automatically gain access to all rows.
2 Likes
Apologies for the confusion. RLS is Row level security.
Also i did exactly what you said. The issue is “user table” has a “Role” column with Manager or agent defined for each user. All other data tables where access needs to be given also has this column called “All Manager Access” and has ‘Manager’ in it. How does Glide understand that both these managers are connected? i.e. Manager written in all the data tables is the same as the ‘Manager’ in “User Table”. Currently the Role column in the User Table is just a “Text” column.
I’m sure i’m doing something stupidly wrong here..?
Have you configured the Role column in your User Profiles configuration?
1 Like
I had not for some odd reason. Anyway i’ve done it now and now in the layout editor’s user profile has all 4 things (name, e-mail, photo and Role) set up.
Current Scenario : Now my user table has these 4 columns with row owner applied on e-mail.
The other data tables now have row owner applied on user e-mail (so the agents can see only their data). I have created a text column named “All Managers Access” and copy pasted the word “Manager” in this column, and have ALSO made this column as row owner.
Result : Same problem. I still have the agents being able to see their rows but managers still cant see anything.
Would you mind showing me some screen shots please?
- Your User Profiles configuration
- Your User Profiles table, showing at least the email and role column, with a few rows visible (redact anything you need to)
- One of your data tables, showing the columns that have row owners applied
2 Likes
Found the glitch. So we are two developers working simultaneously and i’ve enabled the preview feature of “Multiplayer” and this was messing it up. Its also a good learning that glide’s preview features are not that reliable then always
1 Like