row level security

[Remo]

Does anyone ever have added some kind of row level security to syntara? I really like some of the features we get pretty much for free, but for lots of projects I work on, I need to specify things in more details.

Assume you've got a bunch of users, some work in Switzerland and some in France and some in both countries. Lots of table have a foreign key to a country table. I somehow have to make sure I can assign countries to users and later filter the data according on that setting.

I understand that this is probably out of scope to be included in syntara by default, but maybe it could be another package to be added. I'd be willing to work on that, but I'd like to talk about the best way to implement something like that.. Any suggestions?

[MrJuliuss]

Hi, sorry for the late reply. It's a good idea but i don't have any suggestion, i think you must take a look at laravel pivot tables or tables relations.

[Remo]

Adding some relations should be easy, I wonder about the backend / UI: Maybe we can add a way to register "row level security tables" with an id and a name column which are automatically shown in the user screen.. ?