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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Richard Rowell <richard(dot)rowell(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn't work
Date: 2007-08-15 17:19:17
Message-ID: 20070815171917.GE25596@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Richard Rowell escribió:

> perm_test=> revoke create on schema foo from bar;
>
> REVOKE
>
> perm_test=# revoke create on schema public from bar;
>
> REVOKE

You have to revoke from PUBLIC too, otherwise the user still has access
via that one.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2007-08-15 17:44:04 Re: BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn't work
Previous Message Leoj 2007-08-15 16:41:56 BUG #3541: typo - minor importance