From: Robert Treat <xzilla@users.sourceforge.net>
To: rjyoung@scs.carleton.ca
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres setup question
Date: Tue, 21 Sep 2004 02:20:35 -0400
Message-ID: <200409210220.35236.xzilla@users.sourceforge.net> (raw)
In-Reply-To: <1095696276.414eff9484776@www.scs.carleton.ca>
References: <1095696276.414eff9484776@www.scs.carleton.ca>
On Monday 20 September 2004 12:04, rjyoung@scs.carleton.ca wrote:
> Hi there,
>
> I've been looking into configuring Postgres for a small/medium sized group
> of users for a local computer science society. We want to give each user
> their own database, and have it administratable via the Usermin web
> interface (some people will be fairly green, and we felt Usermin gives a
> decent gui to get your legs in postgres (as well as other things the
> society is going to offer.)) Now, the problem is, Usermin has to be
> configured to connect to the template1 database by default (or some other
> database,) and we want the user to connect to use the database with the
> same name as their user account name.
>
> I am thinking of simply allowing users to connect the template1 database
> and the database with their name. Would this be adequate, or will I have
> to make sure that only the postgres user can edit the template1 database?
> I want to make sure the normal users cannot edit the template1 database.
>
I usually hate posts like this, but I am pretty sure phppgadmin will do what
you want.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: xzilla@users.sourceforge.net, rjyoung@scs.carleton.ca
Subject: Re: Postgres setup question
In-Reply-To: <200409210220.35236.xzilla@users.sourceforge.net>
References: <1095696276.414eff9484776@www.scs.carleton.ca> <200409210220.35236.xzilla@users.sourceforge.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox