I've been struggling with this problem for a long time now and will appreciate any help.
I'm using Oracle and pass users/passwords to access the database. uri = 'oracle://' + config.get('sqlalchemy_conf.webuser', '') + ':' + config.get('sqlalchemy_conf.webpassword', '') + '@' + bd_location engine = create_engine(uri) meta.bind = engine Here's how it should work: every time the user logs in, SA creates a new engine with his log/pass or uses the one that was already opened and then uses it. How do i keep the engine (or any other connection identifier) in the Pylons session (can't think of any other way), so user can pass it to the create_session? I was trying to assign engine variable to the Pylons session, but it fails. What happens now is the new user logs in an all the users start using the engine he created. I'm pretty sure the way I'm doing things (unique log/pass for connection) is fairly uncommon, but still that's the way I have to do it for database security reasons. And my guess will be I'm not alone with such an issue. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---