Since migrating my flexible server to postgresql version 16 my admin user can't modify roles anymore.
With version 16 it's mandatory to have WITH ADMIN OPTION on roles to be able to alter them. My problem is that it wasn't the case on version 14 and my admin user doesn't have this option before the migration.
The problem is that we can't add this option after the migration andit is not possible to rollback to version 14 of postgresql. Although in Azure it's not possible to log as a superuser so I'm really blocked right now.
Does anyone has encouter the same issue with migration to postgresql 16 and do you have a solution or workaround for this problem.
Thanks for your help.