On Wed, 3 Jun 2009 20:40:26 +0100, Dave Page <dp...@pgadmin.org> wrote:
> On Wed, Jun 3, 2009 at 8:32 PM, Seb <splu...@gmail.com> wrote: >>> It may be easier to drop the schema altogether, grant your user >>> account access to the postgres database, and then re-create the >>> pgagent schema using your user account. >> Yes, this sounds simpler at this point, although I'm not sure what >> privileges to grant myself to the postgres database? I assume this >> needs to be done while logged in as the postgres user (i.e. after 'su >> - postgres; psql postgres'). Thanks. > Yes, log in as postgres. GRANT CREATE ON DATABASE postgres TO myuser; > should be enough. Great, I can see the Jobs node now using my normal user account. However, right-clicking on the jobs doesn't present an option to create new jobs; it only shows "_Object list report" and "_Run now" options under "Refresh" in the context menu. Any further advice appreciated. Thanks. -- Seb -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
