Hi Alan, Those are the go-to solutions. In my case we aren't using the 4D password system so I can't rely on that. Plus I need actual record level restriction. So to follow your example, I may want a Team to be able to see themselves and other teams in their Club (just making this up) but not teams in other Clubs.
On Fri, May 12, 2017 at 4:33 PM, Alan Chan via 4D_Tech <[email protected] > wrote: > We restricted record access based on Team (Field related to Team and > Member table), Module (menu bar), History (Date) and other access such as > cross team and also by field level such as viewing cost, modifying sales > price, bypassing margin control > or credit control, just name a few, through 4D standard user/group access > feature. > > With combination of all of above, we can restrict/control access from > users on almost all level. > > 4D standard user/groups access are extremely helpful for these kind of > control and we have more than 200 user groups for these purpose. > > Alan Chan > > 4D iNug Technical <[email protected]> writes: > >Hi folks, > >I'd like to hear from some of you who have implemented systems that allow > >for record-level access control in a 4D database. This is the sort of > thing > >where we want to prevent unauthorized users from seeing or inferring the > >'restricted' records. > > > >Theoretically it's pretty easy - include a field on relevant tables called > >'restricted' or some such and the rules are you filter those records out > if > >the user's permission doesn't allow them. Simple enough but, as we know, > >there be devils there. Maybe it's a whole different approach to the > >structure? > > > >I want to hear about the details of what it took to make that work with > >respect to related records, queries on related records, sorting and so on. > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** > -- Kirk Brooks San Francisco, CA ======================= *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
