Thank you for your reply, And once again i must say i love the project. You are correct, Searching many databases for an email would not be feasible. I have come to the conclusion and have been working on trying to create a separate user database just for this purpose, this way the email would be unique to the login, and then redirected to the proper database for the users tenant, and if user is listed for multiple tenants he will get directed to his profile page that will list his or her tenant(s), from there they can choose what tenant they would like to login to. this will also have a tenanttoUser table which will allow for many to many relations from tenant to user and user to tenant and can have different roles for each tenant he or she is assigned (which would be great for a webmaster that that performs services for multiple sites). I have also decided that i will use an ACL type role management system so the owner of a tenant can assign user rights to individual items under a role or user as i have not decided which would be best at the moment, but user defining ACL i feel would stop from creating a role for a single user. Also i want the ACL to be dynamic by content, Menu items, modules, and administration, so think i will have to store the ACL as json so it can be written on a task as items are added. This will help me hide menu items if they are added to a role and that user does not have access to that role rather then block access to a page. I will update you as i get further with this project. and once again thank you for your feedback.
