Skip site navigation (1) Skip section navigation (2)

Re: BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn'twork

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Richard Rowell" <richard(dot)rowell(at)gmail(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn'twork
Date: 2007-08-15 17:44:04
Message-ID: 46C2F513.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
>>> On Wed, Aug 15, 2007 at 11:29 AM, in message
<200708151629(dot)l7FGTdps040132(at)wwwmaster(dot)postgresql(dot)org>, "Richard Rowell"
<richard(dot)rowell(at)gmail(dot)com> wrote: 
> perm_test=# revoke create on schema public from bar;
> 
> REVOKE
> 
> perm_test=> create table test (uid integer);
> CREATE TABLE
 
I think the problem is that bar is automatically a member of public.
 
revoke create on schema public from public;
 
should help.
 
-Kevin
 



In response to

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2007-08-15 19:01:04
Subject: Re: BUG #3541: typo - minor importance
Previous:From: Alvaro HerreraDate: 2007-08-15 17:19:17
Subject: Re: BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group