[Zope-DB] Authenticating Oracle Users
dieter at handshake.de
Thu Feb 10 14:18:35 EST 2005
Remy Pinsonnault wrote at 2005-2-9 12:29 -0500:
>Because what I want to do is not that much authenticate the users on
>Oracle but I need to have their roles and permissions on each and
>every database objects.
>Even if I manage to create dynamic connection objects, I dont know how
>to call the zsqlmethods with the right connections...
I read in the SQLRelay documentation that
1. SQLRelay supports user switching on a per request base (for
2. It can do this because oracle provides a function for this.
If you have user switching (and you maintain a relation between
your Zope users and the Oracle login info) then could
can reauthenticate the Oracle connection on a request basis.
More information about the Zope-DB