[google-cloud-sql-discuss] PostgreSQL: Unable to drop the public schema

To be able to fully administer my database I want to drop the public schema.

By default every user has privileges to create objects in this schema.

I want to be able to create roles that are unable to create any object, therefore I need to be able to control the public schema as well.

Suggestion: On the template1 database of new instances, ensure the public schema is owned by postgres instead of cloudsqladmin. This allows me to drop the schema if needed.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a93ee2c3-cf34-4be8-992b-83e4e595eb75%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.