>>For example, in my CMS, I store permissions to specific modules in such a field,
Exactly! I do the same. No need to query the database to check for a permission. Just put le list in a session variable at login and for every module, check if the permission code for the module is the the user's list. It is 1000 times (at least! ;-) simpler than having a cross table, especially when editing the user's right. Just one field to update instead of deleting all previous rights, then adding new ones, even id no one has change. Unless users may have 1000s of different permissions, it is far simpler. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235680 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
