How can I protect another table’s data , with only one row to a specific user role from the user’s table ?
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.
@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
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.
1 Like
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.
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
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.
1 Like
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.
Yeah, and the fact that both rows in the user table appear to be greyed out possibly confirms this.
3 Likes
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 ?
Sounds like you just need to add a visibility condition to the chart, such that it’s hidden when there is no data?