[Zope-DB] Authenticating Oracle Users

[Remy Pinsonnault]

But one thing is to authenticate the users and another is how can I
connect to the database with the right roles/permissions.

Do I have to create a new ODBC connection object each time a user
connects to the site?

In fact we are trying to migrate an Oracle Developer client/server
application to a Zope application. When you connect on Oracle
Developer you first authenticate on the database and then you are
granted the datbase roles (on insert/update/delete etc.).

Is it possible to do the same with Zope?

Thanks

Remy


On Tue, 08 Feb 2005 18:53:03 +0100, Andreas Jung <lists at andreas-jung.com> wrote:
> 
> 
> --On Dienstag, 8. Februar 2005 12:45 Uhr -0500 Remy Pinsonnault
> <remypinsonnault at gmail.com> wrote:
> 
> > Hi everyone,
> >
> > I am already familiar with DCOracle2 and we recently switched to eGenix
> > ODBC.
> >
> > The point is that we need to authenticate users that already exist in
> > Oracle with all their existing roles and permissions.
> >
> > Is it possible to do this, maybe with exuserfolder,
> > pluggableauthservice or someone can suggest me another product?
> 
> Try both out :-)
> 
> -aj
> 
>