Permissions not updating on Azure Postgres DB (Flexible Server)

Stewart Wareing 0 Reputation points
2023-04-21T09:06:58.52+00:00

Yesterday I was trying to add permissions to an existing User on our Az Postgres DB - Flexible Server. it is for the "public" schema on a database with the PostGIS extension so there is no default PUBLIC role. The basic syntax runs without error

GRANT INSERT on ALL TABLES IN SCHEMA public TO myuser

Yet when I go to add a new row in the table (via QGIS) I consistently get error messages that I don't have the correct permissions. Is this a bug? Or have missed something glaringly obvious? S

Azure Database for PostgreSQL
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
    2023-04-24T16:51:13.4433333+00:00

    Hi, @Stewart Wareing I tried to repro and I was able to add rows on the public schema Here are the steps I followed.

    1. Enables POSTGIS extension. User's image
    2. Created a myuser in the public schema and GRANT myuser. User's image
    3. logged in with myuser and inserted the rows which were successful. User's image

    Please follow the above steps or share your steps for better assistance Regards

    Geetha

    0 comments No comments