Re: BUG #14724: Unable to revoke CREATE privileges on public schema

On 6/30/17 17:14, David G. Johnston wrote:
> -- create a test db
> CREATE DATABASE test
> WITH OWNER = postgres
> ENCODING = 'UTF8';
>
> -- log in as 'postres' and do:
> REVOKE CREATE ON SCHEMA public FROM public;
>
> WARNING: no privileges could be revoked for "public"
>
>
> Query returned successfully with no result in 16 msec.
>
>
> https://www.postgresql.org/docs/9.6/static/sql-grant.html.
>
> "No privileges are granted to PUBLIC by default on tables, columns,
> schemas or tablespaces."
>
> You've been correctly warned that you've attempted to revoke a privilege
> that doesn't exist.

The "public" schema does by default have privileges, and the above
commands do work for me. Maybe there is some silly stuff going on in
the template databases.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services