How can I immediately take ownership of an Azure PostgreSQL table without AZURESU superuser permissions?

Greg Lowell 0

A developer created a PostgreSQL table and now has ownership, causing my PGADMIN backup task to fail. They could fix the issue when they return from vacation, but how can I immediately take ownership without AZURESU superuser permissions? Since AZURE does not provide me with superuser permissions (seemingly) and I am not the owner of the table, I am unable to user the "ALTER TABLE" command to take ownership.

Oury Ba-MSFT 18,616 Reputation points Microsoft Employee

2024-08-26T22:26:26.39+00:00

@Greg Lowell

To change the owner of a database in PostgreSQL, you need to be a member of the role you’re assigning ownership to.

GRANT hub_admin TO <<your_current_role>>;

SET ROLE hub_admin;

ALTER DATABASE "hub-db" OWNER TO hub_admin;

For more information, please go through - PostgreSQL: Documentation: 16: ALTER ROLE
Oury Ba-MSFT 18,616 Reputation points Microsoft Employee

2024-09-03T16:47:33.8133333+00:00

@Greg Lowell I am following up regarding the above issue. We haven't heard back from you since my last comment. Could you please share the status of the issue.

Regards,

Oury

Share via

How can I immediately take ownership of an Azure PostgreSQL table without AZURESU superuser permissions?

Your answer