Peter Eisentraut wrote: > Bruce Momjian writes: > > > I am adding users and groups to pg_hba.conf. > > You know what would be cool? > > GRANT CONNECT ON mydb TO GROUP myfriends; > > and it rewrites pg_hba.conf accordingly. > > Just a thought...
We are actually not that far away. If you create a group for each database, you can grant access to just that group and add/delete users from that group at will. My new pg_group code will do that. Now, as far as rewriting pg_hba.conf, that goes into an area where we are not sure if the master connection information is in the file or in the database. We also get into a chicken and egg case where we have to have the database loaded to connect to it. I am interested to hear where people think we should go with this. -- 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]
