How do members of the Azure_PG_Admin group modify objects owned by others in Azure Database for PostgreSQL?

Ben Eady 1 Reputation point
2022-11-11T01:28:37.23+00:00

Is there any way to ensure that users in the azure_pg_admin group are granted all permissions to all database objects in Azure Database for PostgreSQL?

As we are beginning to use Azure for PostgreSQL we are encountering issues where someone creates a table and I (in the azure_pg_admin group) do not have permissions necessary to drop or modify the table later. It seems that with no super user role it is not possible to have a true admin and therefore objects can be created by others that are unable to be altered. Any workarounds or solutions for this?

Azure Database for PostgreSQL
{count} votes