Hello Group, I'd really appreciate it if I could please get some help on a design issue for an authentication scheme.
Here are some notes on my application: 1. I'm building an on-demand web application. There will be more than one company using this application. Let's say 10 for this example. 2. There will be a common database for authentication. The database will have users and companies. A user can sign in for different companies. 3. Each client will have its own database. Each of the databases uses the same schema. 4. I'd like to have a common login page where a user enters a user id/password. 5. My application would then check the authentication database, find the user, and return a list of clients for which this user is authorized. 6. The user would select a client, and then the application would connect to that client's database. 7. TurboGears would then proceed as normal, using that client's database. I'm using SQLAlchemy for this project. So I guess my specific TG questions are: 1. Is this a good design for an on demand app? Have folks seen anything better in the TG world? 2. I've got a simple module for handling the login page database access. It uses SQLAlchemy. How can I make sure that I used an engine that is shared for each request? Doesn't TG usually do this behind the scenes? Right now I'm handling it all within that simple module for authentication. 3. Upon a successful authentication and selection of company, I'd like to use the TG Identity module to handle authorization. I need to somehow tell the Identity system that a specific user has successfully authenticated. Where's the best place to do that? Thanks for the help here, Matt --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
