Multiple Bank Login Control

Navigation
2

Well, I have my application and every client will have their own database. As each client will have its database, it will also have its user table for login.

So I have

BancoEmpresa1 - User / Password: [email protected]/123

BancoEmpresa2 - User / Password: [email protected]/123

So, I have my login screen with the following fields:

Login / Email: Password:

How do I know how to direct the correct bank to my user? that user Vanessa type, go to their respective bank (BancoEmpresa1) and not fall into another bank?

[Edit] Technology used: Asp.net MVC + Entity Framework

[Edit2] Each client will have its own database and they will be hosted on my server and in order to access the application, they must pass through a single login screen that will also be on my server. Ex: www.sitedoRod.com/apps/login and then direct each user to their respective application and database.

    
asked by anonymous 21.03.2014 / 15:07

1 answer

3

Without reporting in a specific programming language, I'll point out ideas.

1st - MASTER table of logins

One idea was to have a LOGIN table that is not part of any database, after validating whether or not the user exists, to return from that login table, a field that contains the name of the database that that user will have access to , then use that name in all queries.

2nd - Report Database

At the time of login, check the client application for a configuration file, containing the name of the database to use. (Usually used in ConnectionString or some appSettings )

3rd - Verify bank by bank

21.03.2014 / 15:18
Sorting by date in MySQL How to pass arguments to a PHP script via command line?