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

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't work
Date: 2007-08-15 17:44:04
Message-ID: 46C2F513.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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