Putting limits on different security groups

Classic Servoy
1

Hi,

I seem to remember reading somewhere that I could limit a user’s access to records in a table based on the user group. For example, users in the group Customer might only be able to see records in the ‘orders’ table with an orderid > 1000 or a customerid = 18293.

I don’t see any way to do this in the Security settings… is this indeed a feature, or can table access only be turned flat on or off?

Thanks,

Andrew

2

You simply do this by code in a method BEFORE a form is loaded.
You can set a foundset filter or a table filter (see controller node and databaseManager node).

Search the forum. This is covered in a bunch of threads.

Hope this helps.