I have been experimenting with web2py for a while. I have used only sqlite so far. However, in the future I would like to create new a web interface upon our existing mysql database. Currently we are using MS Access based user interfaces. MS Access connects to mysql by using ODBC driver and each user has their own user account and permissions defined in mysql database.
I managed to create a new login_method (mysql_auth.py in gluon.contrib.login_methods) to allow users to login by using their current credentials (defined in mysql database: mysql.user). Next step would be to modify my app so that each database connection will be made by using the credentials of the authenticated user. Currently i have defined one web2py-user in mysql database to allow web2py applications to connect our test database. This is not allowed in our production database! We need to do all the database operations (especially delete, insert and update) by using the credentials of authenticated user. Is this possible in web2py? Teemu
