Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-docs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group