# Row owners not working

**URL:** <https://community.glideapps.com/t/row-owners-not-working/66878>\
**Category:** Ask for Help\
**Tags:** row-owners\
**Created:** [October 10, 2023, 3:40pm UTC](https://community.glideapps.com/t/row-owners-not-working/66878 "2023-10-10T15:40:37Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![larry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry/32/1643_2.png) [@larry](https://community.glideapps.com/u/larry)\
**Post date:** [October 10, 2023, 3:40pm UTC](https://community.glideapps.com/t/row-owners-not-working/66878/1 "2023-10-10T15:40:37Z")

</div>

I have a user and videos table and want to give users access to each video record based on their role. I’ve created row owners in both tables but it’s not working. I’ve provided two screenshots below. Thank you so much in advance for your assistance.

 ![glide-1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/50b0aad889005d97238c93dcfbd213b0aa3d99a2.png)  
 ![glide-2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b32b5faa9588422370a207d16967b30d117e57a9.png)

---

<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:** [October 10, 2023, 3:45pm UTC](https://community.glideapps.com/t/row-owners-not-working/66878/2 "2023-10-10T15:45:57Z")

</div>

The user-access column doesn’t match the email of the current user you are viewing as, so that seems to be working as intended.

As for roles, it’s hard to say what’s happening without first seeing your user profile configuration. Have you configured a Role column in your user profile configuration? Can you show a screenshot of that configuration?

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [October 10, 2023, 3:46pm UTC](https://community.glideapps.com/t/row-owners-not-working/66878/3 "2023-10-10T15:46:51Z")

</div>

And there is no need to apply row owners on non-email columns.

---

<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:** [October 10, 2023, 3:50pm UTC](https://community.glideapps.com/t/row-owners-not-working/66878/4 "2023-10-10T15:50:12Z")

</div>

> [@Hassan\_Nadeem](#):
>
> And there is no need to apply row owners on non-email columns.

Well you would if you are using role functionality, but I agree that I would not do that in a User table…or at least not dual purpose the same column to serve as the user’s role and as a row owner column. I would have a separate Role column in the user table to specify the user’s role in the user profile configuration, and then another Role Access column in the user table that is assigned row owners and used to determine which users can access other user rows, for example an admin may need to access all other users, but a general user should not be able to access other general users or admins.

---

<div class="post-metadata">

**Author:** ![larry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry/32/1643_2.png) [@larry](https://community.glideapps.com/u/larry)\
**Post date:** [October 11, 2023, 3:07am UTC](https://community.glideapps.com/t/row-owners-not-working/66878/5 "2023-10-11T03:07:42Z")

</div>

Here’s the screenshot…

 ![Screenshot 2023-10-10 230651](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dc567839e5a069f8199abfe344d2542391a29428.png)

---

<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:** [October 11, 2023, 3:23am UTC](https://community.glideapps.com/t/row-owners-not-working/66878/6 "2023-10-11T03:23:37Z")

</div>

You have not assigned a Role column, so the user profile has no idea which column in the user table would determine a user’s role. Until you fix that, any row owner columns that have a role value instead of an email will not work at all.

---

<div class="post-metadata">

**Author:** ![larry](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/larry/32/1643_2.png) [@larry](https://community.glideapps.com/u/larry)\
**Post date:** [October 11, 2023, 3:16pm UTC](https://community.glideapps.com/t/row-owners-not-working/66878/7 "2023-10-11T15:16:04Z")

</div>

Thank you so much. You guys are AWESOME!!!

---

<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:** [October 18, 2023, 3:16pm UTC](https://community.glideapps.com/t/row-owners-not-working/66878/8 "2023-10-18T15:16:52Z")

</div>

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