Sample Header Ad - 728x90

Can't grant privileges to regular user for pg_cron

0 votes
0 answers
66 views
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