# Assign Multiple Roles in Glide Tables **URL:** \ **Category:** Ask for Help\ **Created:** [December 31, 2021, 3:33pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534 "2021-12-31T15:33:26Z")\ **Posts on this page:** 20\ **Page:** 2
**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:** [November 10, 2022, 9:55am UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/23 "2022-11-10T09:55:16Z")
Yes, but that doesn’t help with the issue of using Roles as Row Owners in other tables. ---
**Author:** ![Antonino\_Nolasco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/antonino_nolasco/32/80601_2.png) [@Antonino\_Nolasco](https://community.glideapps.com/u/Antonino_Nolasco)\ **Post date:** [November 10, 2022, 10:02am UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/24 "2022-11-10T10:02:36Z")
If you have pro plan you can make a copy of the app where admin can see everything. I use an app for users with row owners and another app with same table but without row owners, so admin can see everything ---
**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:** [November 10, 2022, 10:12am UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/25 "2022-11-10T10:12:17Z")
I think you are missing the point. With a Google Sheet, you can create an array column of roles, assign multiple roles to individual users, and use those roles as row owners in other tables. It’s not possible to do this with Glide Tables, which makes Glide Tables unsuitable for a situation where you have a requirement to assign two or more roles to individual users. ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [February 16, 2024, 3:43pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/26 "2024-02-16T15:43:08Z")
We want to build a GlideApp Customer Portal integrated to an existing ERP solution. Each ERP Tenant has multiple clients and we want to allow each ERP Tentant to allow their Client’s, Contacts access to the Client Data via the Glide Portal. (We plan to set-up an integration using synced postgress tables linked to Glide) The problem I’m experiencing is that in Glide, a user profile and login is done based on the emailaddress of the user. While this emailaddress can be coupled in my ERP to different ERP-Tenant/Client combinations. I need to be able to set-up row-security so that my user can view the data from all the ERP-Tentant/Client combinations her/his emailaddress is linked to in any of the ERP tenants. However it seems I’m only able to add one role in the users table. It also seems to be impossible to add a comma separated list of row owners … Is there a solution to this? This could be a big project but if we can’t do it in a decent way I’m afraid it will be a no go… ---
**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:** [February 16, 2024, 3:53pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/27 "2024-02-16T15:53:47Z")
> [@Tim\_Gestels](#): > > However it seems I’m only able to add one role in the users table. It also seems to be impossible to add a comma separated list of row owners … > > Is there a solution to this? > This could be a big project but if we can’t do it in a decent way I’m afraid it will be a no go… The only solution is to connect a Google Sheet and use it as the source of your User Profile table. You could then assign up to 9 roles per user by creating an appropriate array column in the Google Sheet to use as your Role column in Glide. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 16, 2024, 3:55pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/28 "2024-02-16T15:55:21Z")
It also should be noted that you can have as many individual Row Owner columns as you want, but each one can only contain a single email or role. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 16, 2024, 7:25pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/29 "2024-02-16T19:25:15Z")
Yes, it is great trick with sql! But how to configure so many row owners colums, as many customers? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 16, 2024, 7:36pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/30 "2024-02-16T19:36:01Z")
That’s where Roles come in. If all customers have the same role, then you only need one row owner column for all customers with the same role. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 16, 2024, 8:11pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/31 "2024-02-16T20:11:45Z")
Good, how to achive with this technique to some staff have access to several customers? Probably we must have so many preconfigured wow owners as many staffs we have. Or preconfif many, many unuque roles and distribyte they between customers? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 16, 2024, 8:13pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/32 "2024-02-16T20:13:35Z")
Staff would have a different role and you can create a second Row Owner column filled with the Staff role. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 16, 2024, 8:16pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/33 "2024-02-16T20:16:09Z")
Yes, but we cant expect how many customers will be ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 16, 2024, 8:19pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/34 "2024-02-16T20:19:13Z")
All customers would have the same role. If you had a situation where you wanted row owners for customers and staff, you create two row owner columns. One to hold the customer’s email or role, and another to hold the staff role. If you use Roles, you can have 1000 people with the same role and you only need 1 row owner column. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 16, 2024, 8:22pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/35 "2024-02-16T20:22:39Z")
I can imagine that some backend can dynamically cteates columns, but how to config it as row owner? Just to pre create 10k columns and manually set to row owner, and then with sql dynamically fill they ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 16, 2024, 8:23pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/36 "2024-02-16T20:23:56Z")
Why would you create so many columns. I said 2 columns in the scenario I mentioned. Have you used Roles before? > **[Roles | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/roles)** > > Define roles for your users and build different experiences and permissions. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/5936e1ba0b51747afe20bf844aab4ecbaae55979.png) ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 16, 2024, 8:34pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/37 "2024-02-16T20:34:30Z")
Wow, yes geniously!!! Really we needn’t so many - 2 enoth, if with sql every time we can arrange special values for each columns ---
**Author:** ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)\ **Post date:** [February 16, 2024, 8:35pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/38 "2024-02-16T20:35:59Z")
Hi Darren, Thanks I’m not really accustomed to working with google sheets in Glide. Do you happen to know of any example video so I can test it? Or if you have a moment on Monday to go through it together? No problem if you’d charge your time if I you can help me save some 🙂 ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 16, 2024, 8:38pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/39 "2024-02-16T20:38:43Z")
Really, many thanks Jeff! And sorry for my English! ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 16, 2024, 8:48pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/40 "2024-02-16T20:48:20Z")
But, wait, if row owner have been applyed on server side, but sql table data never goes to Glide server, how it can be applied? And if we can predefine data to download to staff device, so row owner is uselles in this case? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 16, 2024, 8:52pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/41 "2024-02-16T20:52:37Z")
I don’t know how that works with a SQL source since I’ve never used SQL with Glide myself. I assume though that it’s still passing through Glide servers first. I understand what you are saying, but I’m not sure I have the answer for that. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [February 16, 2024, 8:54pm UTC](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534/42 "2024-02-16T20:54:34Z")
Yes, exactly sql data never goes to Glide server. It is main feature [Previous page](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534.md?page=1) [Next page](https://community.glideapps.com/t/assign-multiple-roles-in-glide-tables/36534.md?page=3)