Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema
Date
Msg-id CAKFQuwa-jBUUE0ZAcsRb9j33a-pJdqrDa9QqQeoUoVgaQrJf6g@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema  (zam6ak@gmail.com)
Responses Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on publicschema  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-bugs
Tree view
On Fri, Jun 30, 2017 at 12:18 PM, <zam6ak@gmail.com> wrote:
The following bug has been logged on the website:

Bug reference:      14724
Logged by:          zam6ak
Email address:      zam6ak@gmail.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.

pgsql-bugs by date:

Previous
From: Thomas Kellerer
Date:
Subject: [BUGS] Re: BUG #14718: unable to update table with identity column GENERATEDALWAYS
Next
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on publicschema