[Zope-DB] Authenticating Oracle Users

[Dieter Maurer]

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
    Oracle)

 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.

-- 
Dieter