Re: [SQL] Re: [ADMIN] Apache authentication & PostgreSQL

Поиск
Список
Период
Сортировка
От Christophe Labouisse
Тема Re: [SQL] Re: [ADMIN] Apache authentication & PostgreSQL
Дата
Msg-id m33dzpkw27.fsf@gabuzo.meunet
обсуждение исходный текст
Ответ на Re: [ADMIN] Apache authentication & PostgreSQL  (Fomichev Michael <fomichev@null.ru>)
Список 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 по дате отправления:

Предыдущее
От: Doug Younger
Дата:
Сообщение: trigger to insert on update to non-existing row?
Следующее
От: adrian@ezymail.com
Дата:
Сообщение: Where in the world is pgsql-sql@postgresql.org??