# Yet another permissions / roles questin

**URL:** <https://community.glideapps.com/t/yet-another-permissions-roles-questin/78106>\
**Category:** Ask for Help\
**Created:** [November 21, 2024, 5:31pm UTC](https://community.glideapps.com/t/yet-another-permissions-roles-questin/78106 "2024-11-21T17:31:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DomRainingC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/domrainingc/32/82331_2.png) [@DomRainingC](https://community.glideapps.com/u/DomRainingC)\
**Post date:** [November 21, 2024, 5:31pm UTC](https://community.glideapps.com/t/yet-another-permissions-roles-questin/78106/1 "2024-11-21T17:31:59Z")

</div>

Evening lovely people. Apologies for yet another roles question, but i’m a little stumped!

Our app is an asset inspection and management system for multiple customs.  
We need our own staff to be able to access all client records, but then want our clients to just see their own records. Simple enough right?

Have read/watched/re-read/re-watched all the tutorials a number of times, but afraid am still miffed.

We have multiple tables (Clients/Assets/Inspections). I’ve so far assigned roles to Company name - which works fine, so Clients logging in can just see their own stuff.  
I’m stuck on how I can then allow our own staff to see everything (without adding an extra column to every table with our own Company name in).  
We can of course add the column, but then the issue with making sure the correct name is included in every single new record created - we have 1000’s.

Have i missed something super obvious?

Thanks x 100 in advance,

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [November 21, 2024, 5:52pm UTC](https://community.glideapps.com/t/yet-another-permissions-roles-questin/78106/2 "2024-11-21T17:52:04Z")

</div>

If you are using Google Sheet as you source, you can use constant to make sure the same value is across all the rows:

> [@Constant Role Assignment That Works Like a Glide Template Column!](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028/5):
>
> Actually, no cell in that column should be removed: [image]

---

<div class="post-metadata">

**Author:** ![DomRainingC](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/domrainingc/32/82331_2.png) [@DomRainingC](https://community.glideapps.com/u/DomRainingC)\
**Post date:** [November 22, 2024, 1:43pm UTC](https://community.glideapps.com/t/yet-another-permissions-roles-questin/78106/3 "2024-11-22T13:43:05Z")

</div>

Ahh afraid not - we’re using Glide Tables…  
Anything that can work here?  
Thanks!

---

<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:** [November 22, 2024, 3:03pm UTC](https://community.glideapps.com/t/yet-another-permissions-roles-questin/78106/4 "2024-11-22T15:03:32Z")

</div>

What you should do is give your Staff an appropriate Role, eg. “Staff”, and then add an Owner column to your Data Tables and set that value (“Staff”) in every row.

> [@DomRainingC](#):
>
> We can of course add the column, but then the issue with making sure the correct name is included in every single new record created - we have 1000’s.

You can use copy/paste in the Data Editor to populate existing rows, then modify any forms that add rows to also pass the Staff owner value as either a column or user profile value.

> **[Values | Glide Docs](https://www.glideapps.com/docs/reference/values)**
>
> The different types of values you can work with in Glide.