# Protect another table data for a role or row owner **URL:** \ **Category:** Ask for Help\ **Created:** [August 29, 2022, 7:48am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042 "2022-08-29T07:48:53Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [August 29, 2022, 7:48am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/1 "2022-08-29T07:48:53Z")
How can I protect another table’s data , with only one row to a specific user role from the user’s table ? ---
**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:** [August 29, 2022, 7:52am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/2 "2022-08-29T07:52:03Z")
Just add a column to the table, and fill it with the name of the role that should have access to each row, then make that column a row owner. ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [August 29, 2022, 8:06am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/3 "2022-08-29T08:06:03Z")
@Darren_Murphy I have tried this , but when I change in the design the user , it still can see all the info, even if it’s not that 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:** [August 29, 2022, 8:12am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/4 "2022-08-29T08:12:10Z")
If it’s correctly setup, it should work. Can you add some screen shots of the following: - User Profiles configuration - User Profiles Table, showing column headers for Row Owner and Roles columns - Table you are wanting to apply Row Owners to, showing the Owner column One thing to be aware of is that if you’re switching users in the builder, it can sometimes be a bit flakey when it comes to row owners and roles being correctly applied. But the acid test is the published app. Sometimes you’ll find that it works perfectly in the published app, even when it seems like it isn’t working in the builder. ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [August 29, 2022, 9:57am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/5 "2022-08-29T09:57:56Z")
Here it is 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/482e4a5eaebd38bc6d465caa4c1d7595fc8824cf.jpeg) users ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9952206ab4a42134e1723b64b971da2ede677f8.jpeg) the other table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/8102c54104f80fe2335970797062c5a4d0fcbf0a.png) ---
**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:** [August 29, 2022, 9:59am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/6 "2022-08-29T09:59:56Z")
The problem is in your Users table. You need to remove Row Owner from the “Row Owner” column. In fact, you can delete that column. And you need to add Row Owner to your Email column. ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [August 29, 2022, 10:22am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/7 "2022-08-29T10:22:52Z")
But I want for a specific role … how do I know which one belongs to the manager1 and which one belongs to manager 2 … I just added some demo screenshots … from what I know that configuration should work … no ? This is the example I had from another ticket ---
**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 29, 2022, 12:19pm UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/8 "2022-08-29T12:19:29Z")
Actually, I kind of disagree if row owners are needed in the user table. The Row Owner column looks correct to me if the manager needs to have access to all user rows. The problem is that the Email column ALSO needs to have row owners applied. I could potentially see a weird issue where a user is not granted access to their own row to determine if they have a Role that can be used for row owners…if that makes sense. ---
**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:** [August 29, 2022, 12:29pm UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/9 "2022-08-29T12:29:04Z")
> [@Jeff\_Hager](#): > > Actually, I kind of disagree if row owners are needed in the user table. The Row Owner column looks correct to me if the manager needs to have access to all user rows. The problem is that the Email column ALSO needs to have row owners applied. Yeah, you’re right. For this specific use case, Row Owners would be optional in the User Profiles table. But once that Row Owner-\>Manager column is added and made a Row Owner, then we _definitely_ need the Email column to be a Row Owner. > [@Jeff\_Hager](#): > > I could potentially see a weird issue where a user is not granted access to their own row to determine if they have a Role that can be used for row owners…if that makes sense. Yeah, and the fact that both rows in the user table appear to be greyed out possibly confirms this. ---
**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\ **Post date:** [August 30, 2022, 10:59am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/10 "2022-08-30T10:59:42Z")
I have both columns email and row owner made row owners, in the second table I’ve added the Manager as row owner and it works for all columns except for 2 columns that are rollup columns and the data is displayed inside 2 charts … every data that is not inside a chart is hidden for other users but the charts remain visible … any suggestions to this ? ---
**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:** [August 30, 2022, 11:32am UTC](https://community.glideapps.com/t/protect-another-table-data-for-a-role-or-row-owner/48042/11 "2022-08-30T11:32:13Z")
Sounds like you just need to add a visibility condition to the chart, such that it’s hidden when there is no data?