Re: Suggestion for pgAgent

Dave Page wrote:
> > I asked this question on pgadmin-general before, and
> > there was no reply. Maybe this list is more appropriate.
> >
> > When you configure an SQL job step, you can configure a database
> > on which the script should run, but you cannot specify a database user.
> >
> > I'd like to define schedules for various database users, and
> > while it would be possible to work around the limitation by
> > writing some wrapper functions in the database, the best thing
> > from my perspective would be to enhance pgAgent (and pgAdmin III)
> > to support a database user that pgAgent uses to connect to
> > execute a certain job step.
> >
> > Is that an option? I think it would be a valuable addition,
> > and it would alleviate one of the "security concerns" stated
> > in the documentation.
>
> Sure, it's definitely an option - provided it can be done in a secure
> way. Want to work on it?

I should be able to change pgAgent accordingly, but I am not an
accomplished GUI programmer and have no experience with wxWidgets,
so I don't want to promise that I can do the necessary modifications
in pgAdmin.

Can you think of any security concerns?

Yours,
Laurenz Albe