# Multiple row owners on glide big tables **URL:** \ **Category:** Ask for Help\ **Created:** [September 12, 2025, 9:01am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342 "2025-09-12T09:01:53Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Akshit\_Agarwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/akshit_agarwal/32/91706_2.png) [@Akshit\_Agarwal](https://community.glideapps.com/u/Akshit_Agarwal)\ **Post date:** [September 12, 2025, 9:01am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342/1 "2025-09-12T09:01:53Z")
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 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 12, 2025, 9:26am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342/2 "2025-09-12T09:26:48Z")
> [@Akshit\_Agarwal](#): > > RLS is applied via e-mail Excuse my ignorance, what is RLS in this context? > [@Akshit\_Agarwal](#): > > 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 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. ---
**Author:** ![Akshit\_Agarwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/akshit_agarwal/32/91706_2.png) [@Akshit\_Agarwal](https://community.glideapps.com/u/Akshit_Agarwal)\ **Post date:** [September 12, 2025, 9:32am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342/3 "2025-09-12T09:32:56Z")
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..? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 12, 2025, 9:47am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342/4 "2025-09-12T09:47:01Z")
Have you configured the Role column in your User Profiles configuration? > **[User Profiles | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/user-profiles)** > > Define, store, and use data on your app's users. ---
**Author:** ![Akshit\_Agarwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/akshit_agarwal/32/91706_2.png) [@Akshit\_Agarwal](https://community.glideapps.com/u/Akshit_Agarwal)\ **Post date:** [September 12, 2025, 10:19am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342/5 "2025-09-12T10:19:35Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 12, 2025, 10:25am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342/6 "2025-09-12T10:25:01Z")
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 ---
**Author:** ![Akshit\_Agarwal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/akshit_agarwal/32/91706_2.png) [@Akshit\_Agarwal](https://community.glideapps.com/u/Akshit_Agarwal)\ **Post date:** [September 12, 2025, 11:45am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342/7 "2025-09-12T11:45:27Z")
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 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 23, 2025, 11:38am UTC](https://community.glideapps.com/t/multiple-row-owners-on-glide-big-tables/84342/8 "2025-09-23T11:38:34Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.