I'm using PostgreSQL Flexible server in Azure. My objective is to refresh a materialized view in database "mytest". So i installed pg_cron from Azure server properties, it's installed on postgres database as default.
I can schedule jobs with my Flexible Server Admin user (**myadmin**) but can't do the same with my regular user (lets say '**bob**'). I tried to give usage privilege on cron schema to bob, tried to grant all on tables under cron, but none of them work. the output for trying to grant functions:
WARNING: no privileges were granted for "schedule"
WARNING: no privileges were granted for "schedule"
WARNING: no privileges were granted for "job_cache_invalidate"
WARNING: no privileges were granted for "schedule_in_database"
WARNING: no privileges were granted for "unschedule"
WARNING: no privileges were granted for "unschedule"
WARNING: no privileges were granted for "alter_job"
GRANT
Query returned successfully in 144 msec.
cron schema seems to be owned by **azuresu** which i can't access due to restrictions on Azure.
How can i grant with **myadmin** to **bob** necessary privileges for pg_cron?
Asked by postgresnewbie
(127 rep)
Jan 20, 2025, 02:15 PM
Last activity: Jan 28, 2025, 04:59 AM
Last activity: Jan 28, 2025, 04:59 AM