Share via

Permission Denied in table 'xxx' Issue After Migrating from Single Server to Flexible Server in Azure PostgreSQL

Waleed Asad 5 Reputation points
Oct 21, 2024, 5:04 PM

User's image

Hello Microsoft Support Team,

I am reaching out to request assistance with an issue I encountered after migrating my PostgreSQL database from Single Server to Flexible Server in Azure. After completing the migration, I am unable to execute queries, as I receive a "Permission Denied" error when trying to interact with the tables in the database.

The PostgreSQL flexible database is on v11.

Problem Description:

After migrating the database from Single Server to Flexible Server, I am encountering Permission Denied errors when running queries.

Actions Taken So Far:

  1. I am able to connect to my flexible server.
  2. Checked that no network or firewall rules are blocking access to the database.
  3. Compared server parameters in single and flexible server.

Despite these actions, the issue persists, and I am unable to determine the exact cause of the permission denial.

Please let me know if you require any additional information from my end to investigate this issue further.

Thank you for your assistance, and I look forward to your prompt response.

Best,

Azure Database Migration service
Azure Database for PostgreSQL
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.