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 -- Sent via pgadmin-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
