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 logged in.

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

[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

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.

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 user that's

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