Apologies for the flurry of questions this week. I’ve been going back over my app and trying to improve it / squash issues based on what I have learned since I started building it (this could be an endless cycle!). I’ve spotted an issue with row owners / roles My app if for user by my clients. I h…

[image] sumgii: That’s how I’m thinking, but I can get my head around how to display the right data when it’s needed: For example, in a comment component . Use 2 relations, one to your Public table and one to your Private table, then lookups as needed to retrieve the pieces of info in each ta…

[image] locked_with_key Secure Your Data with Row Owners and Public Profiles Community Resources wave Hey fellow Gliders! Are you using Row Owners and Public Profiles to secure your user data? If not, you might accidentally expose private info. Let’s fix that. …

I just watched that video again. It doesn’t actually add anything to what I said above. It’s the same approach as I suggested of when I mentioned an “unowned table”. Using this approach would solve users being able to see my profile details, but would introduce a new issue: Anything in the public…

Couldn’t you use the same concept, but only add your Admin users to the Public table?

That’s how I’m thinking, but I can get my head around how to display the right data when it’s needed: For example, in a comment component . I might try adding the data as duplicate data to the comments table when each comment is created. Lots of redundancy, but it could potentially work. Out of …

This worked perfectly,. thanks @ThinhDinh . I realise now that I had slightly misunderstood persmissions/roles Because of the “row owner” concept I though that protection would be for the whole row. I didn’t realise that ownership for lookups was from the source table. That makes life much easier…

Row owner / Roles question

Ask for Help

Darren_Murphy February 7, 2024, 5:44pm 2

Topic		Replies	Views
See profiles Ask for Help	13	390	March 21, 2022
Private Pro Role Security Query Ask for Help	7	622	February 24, 2021
Help planning out access & authorisation Ask for Help	4	292	December 30, 2023
User Table & Public User Table Ask for Help	6	192	December 11, 2023
How to control data access? Ask for Help	15	352	November 25, 2022

Row owner / Roles question

Related topics