blacktie524 Posted March 5, 2011 Share Posted March 5, 2011 For example, we have users of 3 types: internal users (employees of our company), clients, and contractors, and they are all in the same table, with a "type" field to differentiate them. We also have different domains for each: internal.domain.com, clients.domain.com, and contractors.domain.com. With each domain mapping to a user type. In order to log in to these portals, you need to have the correct user/pw obviously, and have the user type match the domain as well. Should these users be split from 1 table into 3? One solution that has been mentioned is that the types of users would be classified as "roles", and therefore I would have an ACL to check this role for access to the domain. Any thoughts or input would be greatly appreciated! Link to comment https://forums.phpfreaks.com/topic/229702-should-users-among-inter-connected-domains-be-placed-in-the-same-db-table/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.