SECTION 2.8.4 REVOKE CREATE ON SCHEMA

From: "Timothy Knowles" <timothywknowles(at)hotmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: SECTION 2.8.4 REVOKE CREATE ON SCHEMA
Date: 2003-05-07 01:11:27
Message-ID: Sea1-F145FJ3sl3xbYi0000065f@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2003-05-07 03:42:30 Re: SECTION 2.8.4 REVOKE CREATE ON SCHEMA
Previous Message Robert Treat 2003-05-05 17:00:23 Re: replacing a word in a column