Re: BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn't work - Mailing list 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.