I know that I start with a very open question and hopefully the discussion might lead to different aspects to that very general question at start. I want to develope a multi-user-Database where users (and their accounts) belong to a group that is granted or dissgranted certain set of features (some layouts ar not accessible, some exports not allowed, some field not shown, some tabs not open etc...).
I know that I can set security settings on even a field basis. But even then I sometimes have to calulate or format conditionally in addition to this to make everything happen.
Is it useful to have a "user table" with roles etc. to store these information? Hs anyone seen a general guide or example how to do these things?