postgres-operator icon indicating copy to clipboard operation
postgres-operator copied to clipboard

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

Open wadhah101 opened this issue 1 year ago • 0 comments

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.

wadhah101 avatar Aug 29 '24 10:08 wadhah101