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,
Pennsylvania19026