Skip site navigation (1) Skip section navigation (2)

Re: Apache et postgresql

From: BPascal <pascal62fr(at)free(dot)fr>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: Apache et postgresql
Date: 2008-11-21 09:14:28
Message-ID: 49267BF4.60605@free.fr (view raw or flat)
Thread:
Lists: pgsql-fr-generale
Bonjour,

Problème résolu, j'ai une authentification Apache Postgresql si 
appartenance à un ou plusieurs groupes.

Voici un exemple de fichier .htaccess

AuthName "My PostgreSQL Authenticator groupe charge"
AuthType basic
AuthBasicAuthoritative off
Auth_PG_authoritative on

Auth_PG_host localhost
Auth_PG_port 5432
Auth_PG_user xxxxxx
Auth_PG_pwd xxxxxxxx
Auth_PG_database xxxxxx
Auth_PG_pwd_table "users"
Auth_PG_uid_field user_name
Auth_PG_pwd_field user_passwd
Auth_PG_grp_table "groups"

#Auth_PG_gid_field user_group

Auth_PG_encrypted off
Auth_PG_grp_whereclause " and user_group = 'charge' "
<LIMIT GET POST>
require valid-user
</LIMIT>


A+
-- 
Pascal Brognez
http://www.unr-npdc.org/logiciels

In response to

Responses

pgsql-fr-generale by date

Next:From: BPascalDate: 2008-11-24 14:58:15
Subject: Re: [pgsql-fr-generale][résolu] Apache et postgresql
Previous:From: BPascalDate: 2008-11-20 14:42:17
Subject: Re: Apache et postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group