Postgres Pro
Downloads
Home   >   mailing lists

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

From zam6ak@gmail.com
Subject [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema
Date
Msg-id 20170630191820.1477.86119@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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.



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: [BUGS] *** glibc detected *** postgres: SELECT: double free orcorruption (!prev): 0x0000000001e59de0 ***
Next
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] Fixed PL/Python hint about array of composites