I’m trying to use SecurityProvider (Database type) and SecurityRestrict in order to restrict ServerConnect action. My DB is following users (id, email, password) - list of users accounts (id, title) - list of companies. account_users (id, account_id, user_id, access) - this is user to company me…

Ok, I made several tests and it looks like the following set up works: [image] So answering my questions: Looks like this rules are executed as AND in the SQL query. Although there are no picker in the “Value” field, i put manually GET parameter {{$_GET.account_id}} and seem to work. I would …

Does this help? [image] Two table approach to user security permissions How To As promised i have made a quick video on how to use a multi table approach to user security permissions and the benefits allowing a user to reside in multiple permission groups Sorry, video is …

Thanks, @Hyperbytes . I saw this movie when researching teh forum. In my situation is a bit more complex. Actually I just want to confirm 2 things that I found experimentally - 1) that i can pass GET value as a parameter to permission condition (in the GUI there are no picker), and 2) that 2 diffe…

Am on the road in france at present so cant access a computer but I think I would be taking a look at the actual security file (json file) where I suspect your answers will reside. On the face of it this could well be a viable solution

SecurityProvider - SecurityRestrict on different table

Wappler General Need Help

Hyperbytes October 1, 2019, 1:53pm 3

Does this help?