Postgresql - how to run pg_cron schedules for non-priviledged user

270 Views Asked by At

We use pg_cron extension in out Postgresql 13 environment. There is a demand from users to create their own schedules for particular jobs. Our current implementation is that cron tables/functions are in "cron" schema owned by postgres user. I am sure I could do:

GRANT USAGE ON SCHEMA cron TO user1;
GRANT ALL PRIVILEGES ON TABLE cron.job TO user1;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA cron TO user1;

but I do not like this attitude - it is a security exeption I I would try to avoid this. Any ideas (on abstract level) how to do it?

0

There are 0 best solutions below