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