Topic: Same Rails app accessing separate database for each user?
I am trying to figure out how I can write a Rails web enabled appication that accesses separate and distinct databases based on user. Obviously, the program would have to login to the common database to access the user-privileges. Along with this user information would be the name of the database to use in the MySQL volume (ex:application_User001). From then on, each controller request for the logged in user would be processed against their distinct database.
I see how we set the database addresses in our \config\database.yml and normally the database is application_production. My objective is to have many databases inside MySQL that are accessible based on user privileges.
Thank you for any ideas you might offer.