Peter Eisentraut wrote: > Tom Lane writes: > > > I don't think GRANT CONNECT fits into our setup at all. I also doubt > > that it will be needed very much once we have schemas. > > People have many times asked for a way to alter the connection settings > from within the database. For instance, you add users in the database, > but then you need to go elsewhere to give that user any access. Consider > GRANT CONNECT a built-in editor for pg_hba.conf. You don't have to > actually store the information in two separate places.
I don't know. Automatically modifying a manually maintained config file isn't too common a feature. One problem would be if you where modifying the file in your editor and the backend rewrote the file. I think groups will give use the ability to add/remove connection from within the database. You just need to mention the group name in the config file. My original idea was to automatically identify some group name for each database but maybe that is too smart. -- 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 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
