Help required - Design multiple logins via single interface

Hi Guys,
How would you design a little system that allows different kinds of users to login via single interface but from different tables?

My members are scattered over different database tables (project_admins, project_members, project_guests). It has a reason - that each tables are incompatible due to different data to be recorded.

But, I need to give them one single login point, and then load the functionalities accordingly.

What do you suggest how to handle this?

Wouldn’t this be best handled by having a single user table and then applying “roles” to each of the users?

Look up ACL (Access Control Layer), as it may save you some time :wink:


that’s okay

but you also need a “supertype” users table where every user is registered

do a search for “supertype/subtype”