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
Can you think of any security concerns?
In response to
pgadmin-hackers by date
|Next:||From: Ashesh Vashi||Date: 2009-11-17 12:35:05|
|Subject: Re: PATCH(WIP): Printing Support And Save GQB/Explain as an image|
|Previous:||From: Dave Page||Date: 2009-11-17 04:38:10|
|Subject: Re: Suggestion for pgAgent|