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

On Fri, Jun 30, 2017 at 12:18 PM, <zam6ak(at)gmail(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 14724
> Logged by: zam6ak
> Email address: zam6ak(at)gmail(dot)com
> PostgreSQL version: 10beta1
> Operating system: Windows Server 2012
> Description:
>
> -- 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.

David J.