> see ftp://ftp.eurolink.it/pub/linux/postgreSQL/mod_auth_pgsql
> an authentication module for apache-> pgsql
I was more asking this question about the better policy to follow, than the tools to
use in order to implement this policy.
> I usually do different database/tables per site.
How have you created users/groups in this case (both PG users/groups and Unix
users/group for the HTTPD access) ?
Thanks,
Nicolas Huillard
Nicolas Huillard wrote:
> Hello,
>
> I am hosting web sites on Linux, and want to create databases for these web sites.
> Many virtual Apache web sites are hosted on the same Linux box. Many Postgres
>databases will be hosted on another/the same Linux box. Content administrators will
>be able to access thier databases for their web site, via ODBC, and will not access
>other ones databases.
>
> The question is : how should I setup PG users and groups ?
> * each site has its database
> * all sites are served by Apache under Linux username http
> * each database belongs to a different PG user
> * each content administrator will access his database usgin his username
> * will the web server access all databases using an "http" PG user, or under each
>database owner name ?
> * how can I create groups for each database in order for the content administrator
>not being able to break the structure of his database ?
> * the same with the http user access ?
>
> TIA,
>
> Nicolas Huillard
> G.H.S
> Directeur Technique
> Tél : +33 1 43 21 16 66
> Fax : +33 1 56 54 02 18
> mailto:[EMAIL PROTECTED]
> http://www.ghs.fr
>
> ************
************
