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

[wadhah101]

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.

[flo-02-mu]

I am running into the exact same issue. Your fix works for me.
I wonder what the purpose of these lines actually is:

err = azpg.pg.GrantRole(newOwner, azpg.user)
if err != nil && err.(*pq.Error).Code != "0LP01" {
	if err.(*pq.Error).Code == "42704" {
		// The group role does not exist, no point of granting roles
		logger.Info(fmt.Sprintf("not granting %s to %s as %s does not exist", role, newOwner, newOwner))
		return nil
	}
	return err
}

In all my tests, the value of newOwner and azpg.user were identical, so there was no really a point in doing this role assignment (which fails on pg 16).

[pcallewaert]

I think @flo-02-mu is correct, and the proper fix is to just remove that block of code. I'll look into it to clean up the azure specific code