search

movetokube / postgres-operator

Postgres operator for Kubernetes
MIT License
167 stars 59 forks source link

[bug] Not being able to drop the database due to permission issue #161

Open wadhah101 opened 1 month ago

wadhah101 commented 1 month ago

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.