I created user observer using only postgres user on my PostgreSQL 11 instance and I don't need it anymore. But after all I can't delete it - pgAdmin showing me that my user have connect privileges granted by the cloudsqlsuperuser, and I cannot revoke it to delete my earlier created user account!

somebase=> REVOKE ALL PRIVILEGES ON DATABASE "somebase" FROM observer;
somebase=> DROP ROLE observer;
ERROR:  role "observer" cannot be dropped because some objects depend on it
DETAIL:  privileges for database somebase

I tried to delete it using gcloud cli and CloudSQL console both and failed. So how to delete it now?

  • Have you managed to find a workaround? Jul 3, 2021 at 8:22


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.