Thread: SECTION 2.8.4 REVOKE CREATE ON SCHEMA

Hi All,

Manual: PostgreSQL 7.3 user manual
Section: 2.8.4

Should the revoke statement read:

REVOKE CREATE SCHEMA ON public FROM PUBLIC;

Instead of

REVOKE CREATE ON public FROM PUBLIC;

Without specifying SCHEMA (on my installation at least) the revoke command
complains about an "invalid privilege type CREATE for table object"


Best Regards,

Tim Knowles

_________________________________________________________________
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/mobile

"Timothy Knowles" <timothywknowles@hotmail.com> writes:
> Manual: PostgreSQL 7.3 user manual
> Section: 2.8.4

> Should the revoke statement read:

> REVOKE CREATE SCHEMA ON public FROM PUBLIC;

> Instead of

> REVOKE CREATE ON public FROM PUBLIC;

You mean

REVOKE CREATE ON SCHEMA public FROM PUBLIC;

But yeah, the example is wrong.  Fix committed --- thanks!

            regards, tom lane