Re: BUG #3540: "REVOKE CREATE ON SCHEMA" public doesn't work - Mailing list pgsql-bugs

>>> On Wed, Aug 15, 2007 at 11:29 AM, in message
<200708151629.l7FGTdps040132@wwwmaster.postgresql.org>, "Richard Rowell"
<richard.rowell@gmail.com> wrote:=20
> perm_test=3D# revoke create on schema public from bar;
>=20
> REVOKE
>=20
> perm_test=3D> create table test (uid integer);
> CREATE TABLE
=20
I think the problem is that bar is automatically a member of public.
=20
revoke create on schema public from public;
=20
should help.
=20
-Kevin
=20