postgres-operator
postgres-operator copied to clipboard
[bug] Not being able to drop the database due to permission issue
In the latest version + azure postgres 16 + admin being the privileged azure db user. When we try to drop the database when the CRD is deleted you get
permission denied to grant role "admin"
after some investigation this happens because we try to
GRANT admin to admin;
Only roles with the ADMIN option on role "admin" may grant this role.