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
************
