Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,219 questions
Can't change the owner of a table in azure database for postgreSQL flexible server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 22%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
Yannic Jörg
0
Reputation points
I can't change the owner of a table even though I am using the server admin.
The error message is 'must be able to SET ROLE "ROLE NAME REDACTED"'.
Is there any way to give the server admin the needed permissions? Since it is a managed server, I can't promote the server admin to a super user.
Sign in to answer