pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)

Message-ID: <200409210220.35236.xzilla@users.sourceforge.net>
Permalink:  ../200409210220.35236.xzilla@users.sourceforge.net/
Also on:    postgresql.org/message-id/200409210220.35236.xzilla@users.sourceforge.net

 · 

reply

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