# Limiting access to certain records for certain users **URL:** \ **Category:** Ask for Help\ **Created:** [November 14, 2023, 5:23pm UTC](https://community.glideapps.com/t/limiting-access-to-certain-records-for-certain-users/67800 "2023-11-14T17:23:49Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [November 14, 2023, 5:23pm UTC](https://community.glideapps.com/t/limiting-access-to-certain-records-for-certain-users/67800/1 "2023-11-14T17:23:49Z")
Hi Hoping someone can help with this as it has me stumped! I will have a approx 50 users accessing my app. The main table on the app is called “Breakout rooms” - and that is the table I want to limit access to. Each user will have a role of - Super admin - access to all breakout rooms TRM - Access to approx 5 breakout rooms each. There will be one TRM assigned to each breakout room Tech - only ever access to just one breakout room Am sure there is an easy way of doing this, but I am struggling. Any help much appreciated. Andrew ---
**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, 2023, 5:32pm UTC](https://community.glideapps.com/t/limiting-access-to-certain-records-for-certain-users/67800/2 "2023-11-14T17:32:09Z")
If you are already utilizing Role functionality, then you just need to add three row owner columns to your breakout table. Fill the first column with the Admin role, the second column with the TRM role and the third with the Technician role. ---
**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 14, 2023, 6:04pm UTC](https://community.glideapps.com/t/limiting-access-to-certain-records-for-certain-users/67800/3 "2023-11-14T18:04:15Z")
If I’ve understood Andrew’s question correctly, I don’t think that would get the job done. Here is what I would do: - In the User Profiles table, just a single Role column is required (and should be set as the Role column in the User Profiles configuration). Add the word `Admin` in each of the Admin Users rows. - In the Breakout Rooms table, 3 columns are required with Row Owners applied: – `owner/admin`: a text column, with the word `Admin` in every row – `owner/TRM`: an email column, with the email address of the assigned TRM in each applicable row – `owner/Tech`: an email column, with the email address of the assigned Tech in each applicable row ---
**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, 2023, 6:23pm UTC](https://community.glideapps.com/t/limiting-access-to-certain-records-for-certain-users/67800/4 "2023-11-14T18:23:58Z")
Yeah that probably makes sense. I think I was thinking more along the lines of users having a TRM1, TRM2, TRM3 or Tech1, Tech2, Tech3, role, but email probably makes more sense if there is only one TRM and one Tech per room. I guess along the same lines…if there is only ever one super admin, then a role would be unnecessary and an email could be used as well. ---
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [November 14, 2023, 10:11pm UTC](https://community.glideapps.com/t/limiting-access-to-certain-records-for-certain-users/67800/5 "2023-11-14T22:11:28Z")
You are both wonderful people! Thank you very much. Works perfectly. For some reason I struggle with row owners . Watched the videos, but just can’t get my head around it! Either way - it works - so thank you! ---
**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 26, 2023, 8:53am UTC](https://community.glideapps.com/t/limiting-access-to-certain-records-for-certain-users/67800/6 "2023-11-26T08:53:20Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.