Permission denied for schema cron

Patricia Ramos 0 Reputation points
2024-02-21T14:56:18.5766667+00:00

Hi there!

I am trying to configure the pg_cron extension on our postgresql 16 flexible server, however, I've been stuck for a while now trying to figure out how I am suppose to do anything with the cron schema.

I've added pg_cron to the azure.extensions list, and to the shared_preload_libraries.

When I try to insert a new cron-job, I always get ERROR: permission denied for schema cron. If I do \dn cron I can see that the owner is azuresu. The role I am logged in with is member of azure_pg_admin, however, that does not give me permissions to do grants or anything of that sort regarding the schema...

Am I missing a config parameter or setting?

Any help or tips would be appreciated!

Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rahul Randive 8,671 Reputation points Microsoft Employee
    2024-02-21T16:35:55+00:00

    Hi @Patricia Ramos
    Please check out the similar conversation and the accepted solution below. It seems there was some known issue which was fixed by the product team. https://learn.microsoft.com/en-gb/answers/questions/1026933/permission-denied-for-schema-cron   Thank you!