Re: [SQL] Re: [ADMIN] Apache authentication & PostgreSQL - Mailing list pgsql-sql

From Christophe Labouisse
Subject Re: [SQL] Re: [ADMIN] Apache authentication & PostgreSQL
Date
Msg-id m33dzpkw27.fsf@gabuzo.meunet
Whole thread Raw
In response to Re: [ADMIN] Apache authentication & PostgreSQL  (Fomichev Michael <fomichev@null.ru>)
List pgsql-sql
Fomichev Michael <fomichev@null.ru> writes:

> I want to give different access rights to the database for different
> users (for select, for update, etc.). I can't do this using a pseudo user
> to contact the database. In CGI script I can connect to the database with 
> another username/password then a pseudo user, but I don't know the 
> password of authenticated user. May be there is another way to do this ?

Do you really need to set up password on the database level? As Jan
told you since an authentification is made on the apache level you
know when your CGI is executed that the user entered the right
password so you can create on the database level the same users you
use in apache but with no passwd or with dummy passwords.


-- 
Christophe Labouisse : Cinéma, typographie, Unix
christophe.labouisse@dial.oleane.com http://www.multimania.com/gabuzo/
Le cinéma en Lumière : http://www.lumiere.org/


pgsql-sql by date:

Previous
From: Doug Younger
Date:
Subject: trigger to insert on update to non-existing row?
Next
From: adrian@ezymail.com
Date:
Subject: Where in the world is pgsql-sql@postgresql.org??