Re: user permissions

On Aug 27, 2009, at 2:55 AM, "John" <info@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

Nope

b)      Each task/permission has a list of users that qualify or

Nope

c)       Have a table with a row for each user/permission combination

Sort of. Create two tables a login table with user details and a specific field for a ROLE. Then create a roles table that lists the various permissions. I store this in binary form in one field ( 10001111100100 ) where one means permission granted and 0 means not granted. I assign the permissions thru a form with checkboxes. You could also have permissons assigned to individual fields in the table ( ie fields for update, select, add, delete etc) to make things easier. This process is significantly simpler when managing users, it's easier to adjust permissions on one role than to edit a bunch of users when something changes.

Thanks! John --PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Bastien Sent from my iPod