SECTION 2.8.4 REVOKE CREATE ON SCHEMA - Mailing list pgsql-docs

From Timothy Knowles
Subject SECTION 2.8.4 REVOKE CREATE ON SCHEMA
Date
Msg-id Sea1-F145FJ3sl3xbYi0000065f@hotmail.com
Whole thread Raw
Responses Re: SECTION 2.8.4 REVOKE CREATE ON SCHEMA
List pgsql-docs
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


pgsql-docs by date:

Previous
From: Robert Treat
Date:
Subject: Re: replacing a word in a column
Next
From: Tom Lane
Date:
Subject: Re: SECTION 2.8.4 REVOKE CREATE ON SCHEMA