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

From: zam6ak(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14724: Unable to revoke CREATE privileges on public schema
Date: 2017-06-30 19:18:20
Message-ID: 20170630191820.1477.86119@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2017-06-30 20:58:40 Re: Fixed PL/Python hint about array of composites
Previous Message John R Pierce 2017-06-30 19:14:01 Re: *** glibc detected *** postgres: SELECT: double free or corruption (!prev): 0x0000000001e59de0 ***