search

MrJuliuss / syntara

Admin package for Laravel 4.
MIT License
302 stars 77 forks source link

row level security #155

Open Remo opened 10 years ago

Remo commented 10 years ago

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 commented 10 years ago

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 commented 10 years ago

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.. ?