X-Original-To: pgsql-docs@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id F1C2E475FBA
	for <pgsql-docs@postgresql.org>; Tue,  6 May 2003 21:11:51 -0400 (EDT)
Received: from hotmail.com (f145.sea1.hotmail.com [207.68.163.145])
	by postgresql.org (Postfix) with ESMTP id F1D21474E42
	for <pgsql-docs@postgresql.org>; Tue,  6 May 2003 21:11:23 -0400 (EDT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Tue, 6 May 2003 18:11:27 -0700
Received: from 144.138.196.109 by sea1fd.sea1.hotmail.msn.com with HTTP;
	Wed, 07 May 2003 01:11:27 GMT
X-Originating-IP: [144.138.196.109]
X-Originating-Email: [timothywknowles@hotmail.com]
From: "Timothy Knowles" <timothywknowles@hotmail.com>
To: pgsql-docs@postgresql.org
Subject: SECTION 2.8.4 REVOKE CREATE ON SCHEMA
Date: Wed, 07 May 2003 01:11:27 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <Sea1-F145FJ3sl3xbYi0000065f@hotmail.com>
X-OriginalArrivalTime: 07 May 2003 01:11:27.0562 (UTC)
	FILETIME=[95CDCAA0:01C31435]
X-Spam-Status: No, hits=-0.3 required=5.0
	tests=BAYES_30,SUBJ_ALL_CAPS,UPPERCASE_25_50 version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/4
X-Sequence-Number: 1774

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