Search Postgresql Archives

Re: Feature-Request: Login-Procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2006-05-11 at 05:58, Tino Wildenhain wrote:
> A. Kretschmer schrieb:
> > am  11.05.2006, um 12:30:13 +0200 mailte Tino Wildenhain folgendes:
> > 
> >>I was not aware so many people working at the psql console
> >>regulary :-)
> > 
> > 
> > No? I'm amazed ;-) There are other clients?
> 
> I have the impression most people are working via some
> kind of other application which is using postgres as
> invisible backend :-)

Where I work it's about 75% or so psql, and about 25% other (various gui
tools)

> Btw, greating can be done via .psqlrc or so too :-)

I see this as a two edged blade.

While there are certainly things neither you nor I have thought of that
a login fired procedure could be useful for, there are also going to be
cases of people "reinventing the wheel" with it, i.e. doing things that
should probably be in pg_hba.conf.

OTOH, only the postgres account holder can edit the pg_hba.conf and
reload the database, while you could easily have a user editable table
referred to by a login proc that did something similar, and have the
permissions set so that a certain class of users (i.e. help desk folks)
could edit the settings for a user.

I think a login proc is more of a plus than a minus...  But I'm not the
guy slinging the code (I've been working 60 hours a week for the last
three months...  I barely have time to monitor the lists and answer
simple questions...)


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux