Received: from gabuzo.meunet (IDENT:root@d207.paris-214.cybercable.fr [212.198.214.207]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA18649 for ; Fri, 18 Jun 1999 18:03:25 -0400 (EDT) (envelope-from christophe.labouisse@dial.oleane.com) Received: (from moi@localhost) by gabuzo.meunet (8.9.1a/8.9.1/Christophe Labouisse - 10/01/99) id AAA23423; Sat, 19 Jun 1999 00:01:21 +0200 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Re: [ADMIN] Apache authentication & PostgreSQL References: Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit From: Christophe Labouisse Date: 19 Jun 1999 00:01:20 +0200 In-Reply-To: Fomichev Michael's message of "Tue, 15 Jun 1999 16:38:01 +1300 (PETST)" Message-ID: Lines: 19 X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald" Fomichev Michael 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/