# Row Owner / Security set up

**URL:** <https://community.glideapps.com/t/row-owner-security-set-up/83951>\
**Category:** Ask for Help\
**Created:** [August 21, 2025, 12:37pm UTC](https://community.glideapps.com/t/row-owner-security-set-up/83951 "2025-08-21T12:37:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JamesPatrick](https://avatars.discourse-cdn.com/v4/letter/j/34f0e0/32.png) [@JamesPatrick](https://community.glideapps.com/u/JamesPatrick)\
**Post date:** [August 21, 2025, 12:37pm UTC](https://community.glideapps.com/t/row-owner-security-set-up/83951/1 "2025-08-21T12:37:49Z")

</div>

Hello all!

I have an app that in essence does this

Sales person makes an order

then the sales manager should be able to see the order

and the supplier of the order should see the order

There are multiple sales people, one sales manager but multiple suppliers

how do i set up full security to ensure that

1. a sales person only sees their own sales
2. a manager sees all sales from all sales people
3. the suppliers see orders from all sales people but only where they are the nominated supplier

I know this can be done with data filtering but ofcourse the user, if techy enough can inspect network traffic and pull out all records if they really wanted

Thanks!!

---

<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:** [August 21, 2025, 12:50pm UTC](https://community.glideapps.com/t/row-owner-security-set-up/83951/2 "2025-08-21T12:50:28Z")

</div>

You will need 3 row owner columns in your Orders table. An email column that contains the email address of the sales person. Another that contains the sales manager email. And a third that contains the supplier email. That should be the easiest way to do it as long as each row owner represents one person. Otherwise you will need to start utilizing Role functionality if you want to grant access to single row for groups of multiple sales people, multiple managers, or multiple suppliers…but that doesn’t seem to be the case based on what you described.

---

<div class="post-metadata">

**Author:** ![JamesPatrick](https://avatars.discourse-cdn.com/v4/letter/j/34f0e0/32.png) [@JamesPatrick](https://community.glideapps.com/u/JamesPatrick)\
**Post date:** [August 21, 2025, 1:23pm UTC](https://community.glideapps.com/t/row-owner-security-set-up/83951/3 "2025-08-21T13:23:55Z")

</div>

Thank you jeff.

I have actually just had a thought, the suppliers have multiple staff so it may be required where there are multiple suppliers.

how can imake this work with said role functionality?

---

<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:** [August 21, 2025, 1:34pm UTC](https://community.glideapps.com/t/row-owner-security-set-up/83951/4 "2025-08-21T13:34:29Z")

</div>

You will need a Role column in your user table that is configured for user profile roles. You could fill it a supplier name or ID. Then in your orders table, that third column would contain the supplier name or ID instead of an email address.

> **[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.

> **[User Profiles | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/user-profiles#setting-the-user-profiles-table)**
>
> Define, store, and use data on your app's users.

Just note that things like Roles introduce some restrictions. For example, you cannot change a Role column value via the app. You can only change a role via the data editor, the API, or a server side workflow.

---

<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:** [August 28, 2025, 1:35pm UTC](https://community.glideapps.com/t/row-owner-security-set-up/83951/5 "2025-08-28T13:35:08Z")

</div>

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