Re: [Zope] ZSQL with different user

2005-12-20 Thread J Cameron Cooper
Pier Luigi Fiorini wrote: Alle 18:42, lunedì 19 dicembre 2005, hai scritto: Pier Luigi Fiorini wrote: Hello, I'm developing a Zope application that uses a PostgreSQL connection and several ZSQL objects. People should log in using a Postgres user and ZSQL object should be executed by the user

Re: [Zope] ZSQL with different user

2005-12-20 Thread Pier Luigi Fiorini
Alle 18:42, lunedì 19 dicembre 2005, hai scritto: > Pier Luigi Fiorini wrote: > > Hello, > > I'm developing a Zope application that uses a PostgreSQL connection and > > several ZSQL objects. > > People should log in using a Postgres user and ZSQL object should be > > executed by the user that's log

Re: [Zope] ZSQL with different user

2005-12-19 Thread J Cameron Cooper
Pier Luigi Fiorini wrote: Hello, I'm developing a Zope application that uses a PostgreSQL connection and several ZSQL objects. People should log in using a Postgres user and ZSQL object should be executed by the user that's logged in. Multiple people can be logged at the same time. Unfortunatel

Re: [Zope] ZSQL with different user

2005-12-19 Thread Tino Wildenhain
Am Montag, den 19.12.2005, 15:43 +0100 schrieb Reinoud van Leeuwen: > The postgresql commandline tool psql has a command /user to change the > details of the current connection. Wouldn't it be easier to use a command > like that at the beginning of each database request? Well this \connect

Re: [Zope] ZSQL with different user

2005-12-19 Thread Andreas Jung
--On 19. Dezember 2005 15:32:46 +0100 Pier Luigi Fiorini <[EMAIL PROTECTED]> wrote: Hello, I'm developing a Zope application that uses a PostgreSQL connection and several ZSQL objects. People should log in using a Postgres user and ZSQL object should be executed by the user that's logged in

Re: [Zope] ZSQL with different user

2005-12-19 Thread Reinoud van Leeuwen
On Mon, Dec 19, 2005 at 03:39:51PM +0100, Tino Wildenhain wrote: > Pier Luigi Fiorini schrieb: > >Hello, > >I'm developing a Zope application that uses a PostgreSQL connection and > >several ZSQL objects. > >People should log in using a Postgres user and ZSQL object should be > >executed by the u

Re: [Zope] ZSQL with different user

2005-12-19 Thread Tino Wildenhain
Pier Luigi Fiorini schrieb: Hello, I'm developing a Zope application that uses a PostgreSQL connection and several ZSQL objects. People should log in using a Postgres user and ZSQL object should be executed by the user that's logged in. Multiple people can be logged at the same time. Unfortunat

[Zope] ZSQL with different user

2005-12-19 Thread Pier Luigi Fiorini
Hello, I'm developing a Zope application that uses a PostgreSQL connection and several ZSQL objects. People should log in using a Postgres user and ZSQL object should be executed by the user that's logged in. Multiple people can be logged at the same time. Unfortunately it is not possible because