# User Roles - I messed this up somehow

**URL:** <https://community.glideapps.com/t/user-roles-i-messed-this-up-somehow/77894>\
**Category:** Ask for Help\
**Created:** [November 14, 2024, 1:39am UTC](https://community.glideapps.com/t/user-roles-i-messed-this-up-somehow/77894 "2024-11-14T01:39:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Safe\_Supply](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/safe_supply/32/62703_2.png) [@Safe\_Supply](https://community.glideapps.com/u/Safe_Supply)\
**Post date:** [November 14, 2024, 1:39am UTC](https://community.glideapps.com/t/user-roles-i-messed-this-up-somehow/77894/1 "2024-11-14T01:39:52Z")

</div>

I’ve somehow muddled up trying to enable user roles. I need school principals and admins to view the same row - they will be on different email addresses. We are loading up the details for them to view their water sources to check it and add and details. Whenever I set row owners on the ‘roles’ column I don’t see all the data available which should be available for all the users that match the roles - which I’ve set as different school names for simplicity. This data is held not on the user sheet but a secondary google sheet. I tried mimicking Robert’s video but just can’t crack it!

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/40c56070734f2e68e110eacb4e3edd9dc4379b01.jpeg "Glide 101: Row Owners vs. User Specific Columns") ](https://www.youtube.com/watch?v=sclFwC6eov8)

---

<div class="post-metadata">

**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:** [November 14, 2024, 2:24am UTC](https://community.glideapps.com/t/user-roles-i-messed-this-up-somehow/77894/2 "2024-11-14T02:24:59Z")

</div>

> [@Safe\_Supply](#):
>
> Whenever I set row owners on the ‘roles’ column

Don’t do this. It just makes things confusing. The Role column in the user table should only be used to hold the role of the user and that’s it. Don’t make the role column a row owner column at the same time.

If you need to apply row owners to the user table, first set the email column as a row owner column. Then create separate row owner columns that will contain roles for each additional user role that should have access to that row.

In all other tables, create separate row owner columns that will contain either email addresses or roles for each user that should have access to that row.

---

<div class="post-metadata">

**Author:** ![Safe\_Supply](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/safe_supply/32/62703_2.png) [@Safe\_Supply](https://community.glideapps.com/u/Safe_Supply)\
**Post date:** [November 14, 2024, 11:28pm UTC](https://community.glideapps.com/t/user-roles-i-messed-this-up-somehow/77894/3 "2024-11-14T23:28:12Z")

</div>

Thank you Jeff, that’s fixed it nicely.  
I had some redundant rows that I cleaned up and now its working well!

---

<div class="post-metadata">

**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:** [November 21, 2024, 11:28pm UTC](https://community.glideapps.com/t/user-roles-i-messed-this-up-somehow/77894/4 "2024-11-21T23:28:38Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.