Re: Password sub-process ...

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-hackers@postgresql.org
Date: 2002-07-30T03:02:17Z
Lists: pgsql-hackers
Bruno Wolff III wrote:
> On Fri, Jul 26, 2002 at 13:55:58 -0300,
>   "Marc G. Fournier" <scrappy@hub.org> wrote:
> > 
> > As an example ... at the University I work at, we've started to use PgSQL
> > for more and more of our internal stuff, and/or let the students start to
> > use it for their projects ... so we have PgSQL running on one server,
> > while its being access by other ones around campus.  I'd like to be able
> > to be able to streamline things so that operations could easily create a
> > new database for a student (or faculty) on the server as a simple SQL
> > "CREATE DATABASE/USER" command, vs risking them making a mistake when they
> > manually edit the pg_hba.conf file ...
> 
> >From what I read in the development docs, in 7.3 you will be able to just
> do a createuser and createdb to make things work. There will be a "sameuser"
> user specification which will allow access to a database with a matching name.

Actually, there is a 'samegroup' iu 7.3 too, so you can create the db,
create the group, and add whoever you want to the group.  Pretty simple.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026