Execute Permission missing for cron.alter_job for azure_pg_admin

Mani Mahesh Sivakumar 56 Reputation points
2022-08-24T10:11:13.16+00:00

234415-permission-issue.png

Hi Team,

For Scheduling jobs in different databases, we must need to use cron.alter_job or cron.schedule_in_database functions available inside cron schema. But in my flexible server, both functions are having only execute permissions for azuresu user. Because of that i could not schedule jobs. In other subscriptions I could see that execute permissions for both azuresu and azure_pg_admin. Kindly help in resolving the same. My flexible server version:13.7

Thanks and regards,
Manimahesh S

Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 28,617 Reputation points Microsoft Employee
    2022-08-24T14:00:17.41+00:00

    Hi, @Mani Mahesh Sivakumar Welcome to the Microsoft Q&A Platform, and thanks for your query.
    If you move pg_cron to another DB you can do everything, only if it stays in Postgres you aren't able to do much.

    234533-image.png

    Try to change this to any database owned by a normal user.

    Please let me know if you find any issues.

    Regards
    Geetha


0 additional answers

Sort by: Most helpful