# Row Owner issue

**URL:** <https://community.glideapps.com/t/row-owner-issue/79945>\
**Category:** Ask for Help\
**Tags:** row-owners\
**Created:** [February 10, 2025, 6:15am UTC](https://community.glideapps.com/t/row-owner-issue/79945 "2025-02-10T06:15:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![manthe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manthe/32/49614_2.png) [@manthe](https://community.glideapps.com/u/manthe)\
**Post date:** [February 10, 2025, 6:15am UTC](https://community.glideapps.com/t/row-owner-issue/79945/1 "2025-02-10T06:15:08Z")

</div>

Hi all.

I am creating an app that can be used by multiple businesses, and within every business there can be several users.

I collect all users in the user table with email and a business\_ID column.

THen I have another native glide table that has a lot of rows with “business information”. Every row have the same business\_ID that extist in the user table, and I have a lookup column that matches all the users that belong to this business\_ID since they all should be able to view the content for this business\_ID.

I want to set the lookup column as row owner to secure the data, but that option is not visible on a lookup column.

I tried a few other ways but cannot get any of them to work.

How can I set a row owner column in a table and then let several differet users from the user table to view the data of the business\_ID they belong to?

Cheers Måns

---

<div class="post-metadata">

**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 10, 2025, 6:22am UTC](https://community.glideapps.com/t/row-owner-issue/79945/2 "2025-02-10T06:22:36Z")

</div>

- Go to your User Profiles Configuration (Settings-\>Users & Authentication-\>Edit User Profiles), and set the business\_ID column as the Role
- In your Business Information table, apply Row Owners to the business\_ID column.

---

<div class="post-metadata">

**Author:** ![manthe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manthe/32/49614_2.png) [@manthe](https://community.glideapps.com/u/manthe)\
**Post date:** [February 10, 2025, 7:52am UTC](https://community.glideapps.com/t/row-owner-issue/79945/3 "2025-02-10T07:52:04Z")

</div>

This looks very promising 😀

Will try it out in a couple of hours and let you know @Darren_Murphy

/Mans

---

<div class="post-metadata">

**Author:** ![manthe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manthe/32/49614_2.png) [@manthe](https://community.glideapps.com/u/manthe)\
**Post date:** [February 10, 2025, 3:27pm UTC](https://community.glideapps.com/t/row-owner-issue/79945/4 "2025-02-10T15:27:45Z")

</div>

@Darren_Murphy Wohoo!, this works like a charm. I also used a collection of specific business data, that relate to the business table, and used the relation from those tables as data source (thing in things…) and it works perfect.

Thank you for this.

I still dont really understand how this works?

I have used the Role for other things previousely but not like this.

Is it correct to say that if the business\_ID column in the users table have the same value as the row owner column in any other table, I can see the data, otherwise I cannot see the data…

/M

---

<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:** [February 10, 2025, 3:40pm UTC](https://community.glideapps.com/t/row-owner-issue/79945/5 "2025-02-10T15:40:04Z")

</div>

Yes, any table under row ownership will only download data where the row owner column value matches the sign in user’s email or role.

---

<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:** [February 17, 2025, 3:40pm UTC](https://community.glideapps.com/t/row-owner-issue/79945/6 "2025-02-17T15:40:08Z")

</div>

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