GRANT ALL PRIVILEGES ON DATABASE mydatabase ON SCHEMA public TO ;
这句话会导致角色存在依赖表空间无法删除,按下面处理一下就好
REASSIGN OWNED BY 要删掉的 TO 随便什么角色名;
DROP OWNED BY 要删掉的;
-- repeat in ALL databases where the role owns anything or has any privileges!
DROP USER 要删掉的;