> -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Carsten Klein > Sent: Monday, July 12, 2010 11:54 AM > To: [email protected] > Subject: Re: [Trac-dev] Refactoring the Trac data model - relational > approach > > > > I'll concede there's nothing intrinsically wrong with it in the > context > > of it's own self contained purpose. I guess my actual beef with it is > > there's no mechanism (that I know of) to check whether a User is in a > > group, as opposed to has a permission, but that's more of a software > > Here would be some queries for it, if you need them: > > All defined groups > > select distinct username from permission where username not in (select > distinct action from permission);
Remember that groups can be provided by things other than the default backend, for example from LDAP. You can never rely on the DB to know these things in anything related to reusable code. --Noah -- You received this message because you are subscribed to the Google Groups "Trac Development" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-dev?hl=en.
