On Jun 30, 2006, at 2:41 PM, Eric J. Hoffman wrote: > I am looking for something more along the lines of role based in such > that each level/group would then get x y and z permissions, etc. > Second > level, just y & z permissions, etc
I rolled my own for this. * You start with a Users table with the usual data. * Then you have a Groups table that is just a series of group names. * Then you have an Actions table that lists the possible actions. * Have a Users-to-Groups many-to-many cross reference table (I'm sure there's a simpler term for this) that matches user_id to group_id. This allows each user to be in multiple groups. * Have a Groups-to-Actions many-to-many cross reference table that matches group_id to action_id. * In your application.cfm or .cfc query the user's ID against the groups and then the actions to see what actions are permitted (lots of "select .. where is in (...)" statements), if they're not permitted then display a warning message. Then just write a small admin app to manage them all and structure your groups any way you want. That isn't a perfect design but its workable. Anything else? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include <stdjoke.h> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
