Bruno Wolff III wrote: > On Fri, Jul 26, 2002 at 13:55:58 -0300, > "Marc G. Fournier" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]