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