This is where binary is actually helpful. You can store each task/permission as a bit, ie, as a yes or no piece of data.
For example: read, write, edit, moderate ... a user with read/write permissions only would be represented by: 1100, which in decimal is 12. So in effect, you're storing 4 values in one integer. If you wanted to create a table to serve as a key to the permission level codes, you could do that as well. RO On Wed, Aug 26, 2009 at 11:55 PM, John<i...@dynatechdesign.ca> wrote: > Hi, > > > > What is the best way to assign permissions to users? > > > > a) Each user has a list of permissions associated with that user or > > b) Each task/permission has a list of users that qualify or > > c) Have a table with a row for each user/permission combination > > > > Thanks! > > > > John > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
